Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select records and fill in default value when empty?
Message
 
 
À
10/09/2004 09:47:03
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00941026
Message ID:
00941029
Vues:
8
This message has been marked as the solution to the initial question of the thread.
Yes.
..., EVL(po_greetin, po_name) AS po_greetin, 
* or if EVL() isn't available
..., IIF(EMPTY(po_greetin), po_name, po_greetin) AS po_greetin,
>I have a table where some of the fields are:
>
>po_name
>po_greetin
>
>I want to do a sql select that pulls all of the records in the table but where po_greetin is empty, I want it to substitute the value in po_name. Is that possible? I don't recall every seeing anything like that here on the UT and I don't see anything in Help about it.
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform