Archives of the TeradataForum

Message Posted: Tue, 04 May 2004 @ 13:17:22 GMT

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

Shrinivas:

If you are going to concatenate the data columns together and allow nulls in any column, the columns should be selected using the COALESCE(column-name,''). This way, the record will contain a zero length character instead of a null.

Hope this helps.

Michael Larkins
Certified Teradata Master

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