Archives of the TeradataForum

Message Posted: Fri, 29 Jul 2005 @ 13:02:03 GMT

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

Ananth,

You can use coalesce to suppress nulls

     Coalesce(co1,col2,......)

First column which is not null is taken as value of that column.

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