Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP IIF() function replacement
Message
From
07/11/2003 14:22:55
John Kang
Glendale, California, United States
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
VFP IIF() function replacement
Miscellaneous
Thread ID:
00847773
Message ID:
00847773
Views:
69
In VFP I could do:

SELECT IIF(EMPTY(field1),field2,field1) AS field...

to pull data conditionally in from either field between two fields in a table. Is there a way to do this in MSSQL? TIA.
It's "my" world. You're just living in it.
Next
Reply
Map
View

Click here to load this message in the networking platform