Can you use IIF(a,b,c) in a SELECT statement? - Level Extreme

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 09:52:41

Marty Smith
Virginia Beach, Virginie, États-Unis

À

13/11/2000 09:40:44

Robert Keith
Independent Developer
San Antonio, Texas, États-Unis

Information générale

Forum:

Visual FoxPro

Catégorie:

Autre

Titre:

Re: Can you use IIF(a,b,c) in a SELECT statement?

Divers

Thread ID:

00440969

Message ID:

00440982

Vues:

11

>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

Click here to load this message in the networking platform