Archives of the TeradataForum

Message Posted: Fri, 29 Sep 2006 @ 09:27:23 GMT

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

Hi,

In that table there are only two columns, if I change the SQL from

     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','')
     ; /* This SQL was running fine till last month, but now it's not */

To

     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','')
     UNION
     select distinct cast(
            cast(A as char(10))||
            cast(B as char(60))
            as char(70))
     from DEV.Table
     where not trim(A) in ('THIS_IS_NOT_CORRECT')	;

Then it works fine.

Any suggestions.

Regards,

Tanu.

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