Friday, March 30, 2012

Immediate IFF() ?

Is there an Immediate IFF() function in SQL 7.0?
I'm trying to do this:
INSERTINTO Myfile(Name,IFF(TDate='',Ddate,Tdate)
SELECTd.Name, d.tdate
FROMMasterfile d, Anotherfile s
WHEREd.Name = s.Name
thx,
mac
>> Is there an Immediate IFF() function in SQL 7.0?
No, in most cases, CASE expressions would suffice. For details and other
alternatives, read through the topics CASE, COALESCE, ISNULL & NULLIF in SQL
Server Books Online.
Anith
sql

No comments:

Post a Comment