Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Query for empty?
Message
 
 
À
23/04/2010 12:41:19
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01461752
Message ID:
01461755
Vues:
69
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform