Archives of the TeradataForum

Message Posted: Fri, 29 Sep 2006 @ 14:18:48 GMT

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

Did you try with this?

     select distinct cast(
            cast(A as char(10))||
            cast(B as char(60))
            as char(70))
     from DEV.Table
     where trim(A) <> 'NA'
     and trim(A) <> ''
     ;

It'll helps if you send the UPI (or NUPI) of the table.

Bye.

Castelli, Emanuel Alejandro
Desarrollo DataWarehouse - IBM Argentina

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