Archives of the TeradataForum

Message Posted: Thu, 04 Nov 2004 @ 18:06:39 GMT

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

     Select
     Case  when (ColA = 1002 and ColB is not null) then  ColC
           else  date'2004-05-05'
           End
     From  Clay_Case_Date

Rakesh Gandham
WBBIS

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