Archives of the TeradataForum

Message Posted: Wed, 09 Aug 2006 @ 18:07:38 GMT

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

Hi Ram,

You can use CAST function with CHAR(n) to eliminate the extra character (at the leftmost) from the output.

eg.

     SELECT CAST( col1 | "~" | col2  AS CHAR(80)) FROM Tbl;

Regards,

Murali D.

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