Archives of the TeradataForum

Message Posted: Fri, 29 Sep 2006 @ 13:11:16 GMT

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

Hi,

Both of the columns which are being used in the SQL:

     select distinct cast(
            cast(A as char(10))||
            cast(B as char(60))
            as char(70))
     from DEV.Table
     where not trim(A) in ('NA','');

Regards,

Tanu.

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