Archives of the TeradataForum

Message Posted: Mon, 12 Jan 2004 @ 11:26:59 GMT

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

Hi All,

I have a table with the following rows.

C1     C2
=========
1       AB
1       BC
1       CA

I have to concatenate all the values of C2 in to a single field for a given C1 value like this.

C1        C2
===============
1       AB BC CA

Do u have an idea how to do this. ? I am not supposed to use a shell script for this.

Thanks, Vivek.

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