Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
And and Or in one SQL Statement
Message
 
 
To
07/10/2004 09:25:40
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00949508
Message ID:
00949509
Views:
12
>How can I create an SQL statement that gets all records of one field value and the true condition of a second field or a not empty of a third field?

When in doubt, use parenthesis.
 WHERE (field1="ABC" AND field2) OR NOT EMPTY(field3)
*
 WHERE field1="ABC" AND (field2 OR NOT EMPTY(field3))
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform