Archives of the TeradataForum

Message Posted: Tue, 20 Dec 2005 @ 11:47:47 GMT

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

Hi,

Instead of writing COALESCE for 100 times or for all columns that have NULL values, You can use following query to get it done.

     select
     'COALESCE(' || trim(columnname) || ', '' '')'
     from dbc.columns
     where databasename='DBNAME'
     and tablename='TABLENAME'

Thanks,

Kavitha

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