Dominic,
Don't have VFP8 yet, so I can't confirm your observation. But I must ask the obvious question: are you absolutely sure you have an index on the field in question?
>
>
>SELECT * FROM table WHERE (field = 'abc' and SomeFunction(field))
>
>
>In the past, this query would test field='abc', and if not, not carry out the second test SomeFunction(field). This behaviour allows select commands to be optimised - check the quick things before checking the slow things.
>
>However, in VFP 8 every single expression in an SQL command appears to be evaluated. In the above example the SomeFunction(field) test is always carried out, regardless of whether field = 'abc'.
>
Steve Gibson