Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can you use CASE statement in SELECT clause
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Can you use CASE statement in SELECT clause
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2003
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01377873
Message ID:
01377873
Views:
81
Can you use a CASE statement in a VFP query (similar to SQL Server)? If not, what is the best way to populate a field if it is empty when running a query? I want it to have something like 'View Record' if the field is empty or the field value if there is something in the field. Hopefully this makes sense. Thanks.

Doug
Next
Reply
Map
View

Click here to load this message in the networking platform