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).
>