SNIP
>
>Perhaps VFP could have been designed to do what you are describing...but if you have the correct indexes, it is not relevant.

Steve,

On the premise that VFP's SQL *will* test ALL parts of an expression with ANDs, what does having the proper indexes in place have to do with preventing it or not?

I could see myself being pretty disappointed if I had some rather onerous function but knew that it would execute on less than 1% of the records because my first condition filtered out 99%+, only to learn that it ran on all records anyway.

Have I missed something here?

>
SNIP