Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select records and fill in default value when empty?
Message
 
 
To
10/09/2004 09:47:03
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00941026
Message ID:
00941029
Views:
7
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform