>Agnes,
>
>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
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]