Archives of the TeradataForum

Message Posted: Thu, 16 Dec 2004 @ 20:33:31 GMT

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

     Create table codes(code_id char(4));

     ins codes('abcd');
     ins codes('aaaa');

     select (CASE
                 WHEN  code_id <> 'abcd'
                 then 'didnt find it'
                   else 'found it'
            end)
     from codes
     ;

     
     ------------------
     found it
     didnt find it

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