Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Larry,
I've tried it with the EMPTY() also and got it to work at first. However, that's because there isn't an index on "EMPTY(TestField)". If you add an index on "EMPTY(TestField)", the EMPTY() won't work either.
Thanks,
Jonathan
>While I can't really explain what's going on with the Indexing, the 2nd SQL statement appears to work if you use the EMPTY() function. In fact, you should always use this function (IMO) instead of an empty string because of the way VFP compares strings (see Jim's post).
>
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement