Hi Jim,

>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?

the indexes help to describe or define a sub-set to be analyzed.
AFAIR you are not guaranteed the order of the sql-evaluation (of this sub-set), only the correctness.

regards

thomas