Archives of the TeradataForum

Message Posted: Wed, 14 Jul 2004 @ 17:28:55 GMT

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

OK try this:

     SEL customername || 'abc' || custid || (CASE WHEN customername
             || 'abc' = 'something' THEN '1' ELSE '0' END) FROM customer;

It is kind of verbose but it works.

Edmond Ray
Senior Data Warehouse Consultant
Special Programs, NCR Government Systems

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