Archives of the TeradataForum

Message Posted: Tue, 07 Dec 2004 @ 09:34:06 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi All ,

Sel '1','2','4','3','5',',6','7','8','9' will give a Nine column output.

But I want them in a single column like a string .. "'1','2','4','3','5',',6','7','8','9' "

TD doesn't have replace function so that I can take out the " ' " and select as a string ..

Is there any way to get this in Teradata ?

I cannot do concat as the Input I get is from a variable and of the format 'x','y','z'...

Thanks

Jebaseelan
DELL Inc

	<Prev	Next>		<<First	<Prev	Next>	Last>>