As pointed out elsewhere in this thread, the workaround is to place the slow function in an IIF.

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