Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can you use IIF(a,b,c) in a SELECT statement?
Message
De
13/11/2000 10:29:29
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00440969
Message ID:
00441006
Vues:
15
>>>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.
>
>You need to make sure you pad out the field to the proper number of characters. Otherwise if the first record selected is "Male" the others will get truncated to "Fema"
>
>use PADR()
>
>or simply
>
>IIF(alias.gender = "M", "Male ", "Female")
---------
Hi Dan and thanks for reminding me...:)
Robert Keith
Independent Developer
San Antonio, Texas
E-mail address:
rebelrob1@yahoo.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform