Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can you use IIF(a,b,c) in a SELECT statement?
Message
 
To
13/11/2000 09:40:44
Robert Keith
Independent Developer
San Antonio, Texas, United States
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Re: Can you use IIF(a,b,c) in a SELECT statement?
Miscellaneous
Thread ID:
00440969
Message ID:
00440982
Views:
14
>I am trying to use IF logic in SELECT statement. any ideas?

Try formating it like this:

SELECT IIF(alias.gender = "M", "Male", "Female") AS GenderText FROM Customers

M.
Marty Smith, CSQE
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform