Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
IIF() and MIN()
Message
 
 
À
03/07/2004 16:46:23
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Titre:
Divers
Thread ID:
00920484
Message ID:
00920490
Vues:
17
This message has been marked as the solution to the initial question of the thread.
>I am moving from FoxPro to SQL and would like to know if this is an equivalent SQL function to FoxPro's IIF() and MIN()
>

You can replace IIF() with CASE function. There's MIN() aggregate function in T-SQL, the same as in VFP select. If you're refering to VFP MIN() function, as in MIN(a,b), than there isn't one in T-SQL , but you can easily get the same result with CASE function.
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform