>>I'm not sure how the index works exactly. We may have an index with FOR clause, e.g.
>>index on myField FOR !DELETED() Then this index could be used in SQL as well, if I recall correctly.
>
>Filtered indexes can be used for optimization only in VFP9.
>In previous versions you have to have index by DELETED().
Right. He didn't say which VFP version he is using.
Or may be Sonny is a woman's name? Hard to tell.
If it's not broken, fix it until it is.
My Blog