Archives of the TeradataForum

Message Posted: Tue, 20 Dec 2005 @ 10:58:04 GMT

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

Hi,

You can create a new table with same DDL and populate the table And while populating the table, use COALESCE in SELECT Query.

     INSERT INTO TABLEB
     SELECT
     Cola,
     COALESCE(colb,' '),
     COALESCE(colc,' '),
     Cold.....
     From TABLEA;

This is one method. There can be many other creative ideas also.

Thanks,

Kavitha.

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