>>My tests showed, much to my surprise, that LIKE was not optimized.
>
>Our tests showed partial optimization for LIKE clause and full optimization for =. Now, I thought I read somewhere that VFP 9 has full optimizable LIKE, but I don't remember, where I read it, so do not know, if it's true.
>

VFP 9 can now fully optimize LIKE with a "%" wildcard at the end of the comparison string.

Tamar