Archives of the TeradataForum

Message Posted: Mon, 05 Jun 2006 @ 14:18:35 GMT

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

Hi Raghu,

Use the following query for the desired result set:

     sel
     CAST (CAST (a as char(10))
     ||'|'||  CAST (b as varchar(60)) AS CHAR(70))
     from tablename
     ;

Regards,

Tanu.

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