Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Query for empty?
Message
 
 
To
23/04/2010 12:41:19
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01461752
Message ID:
01461755
Views:
68
This message has been marked as the solution to the initial question of the thread.
>Hello All!
>so im wondering if i can write a query that brings up only empty records.
>ive been trying
>
>select otest.*;
>from;
>mainbase!otest
>where otest.emailadd=' '; && or where otest.emailadd=" "; 
>order by firstname
>
>
>but ill take every1 with email addresses :(

where empty(otest.EmailAdd) && Not Rushmore optimized.

or

where Otest.EmailAdd ==""
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform