From what Cindy posted in
Re: Problem with ISBLANK and SELECT SQL Thread #
801174 Message #
801310, it looks like the problem I described still exists in VFP7 and VFP8...
>>
>>My tests with VFP6 show that *none* the syntaxes below work correctly. They retrieve the isblank() or empty() value from the current record at the time the query begins. IOW, if you are sitting on the 1st record when you run the query, and it is empty() on that field, it will show that all the records are empty.
>
>I can not test on VFP 6.0.
>
>Agnes
Steve Gibson