>VFP-SQL respects SET DELETED status.
>
>>snip...
>>
>>Are you sure? I thought I read awhile back in the UT that SQL ignores SET DELETED status. However when I tried to go back and search the archives on this I couldn't find the thread, so maybe I was just smokin. If I can trust that SQL will abide by SET DELETED ON then I don't need to worry I suppose.
>>
>>>Don't include DELETED() in Select. Instead SET DELETED ON. VFP will take care of rest.

At one point there was a documented bug with VFP 5.0 (and set deleted on) where it would not ignore deleted records if you were doing distinct count on a field. It would only work if you included "where not deleted()" in your statement. I don't have version 6 yet, but I would assume that it has been fixed........