>>Naomi,
>>
>>Thanks for the reply.
>>I switched the WHERE parameters but no luck.
>>According to Taming Visual FoxPro's SQL page 90 though, "MY KEY" should be on the left.
>>
>I agree with Naomi and have the feeling that you are mis-reading the book (or I am mis-reading your query). The coding should be

>WHERE < Key Expression > = < value >

>where < Key Expression > exactly matches an expression in one of the index tags.
>
>The latest time I had this problem it was because there was a FOR clause in the index expression (Many thanks to those here who solved that problem for me) which makes it non-optimizable.
>

That's not exactly true for VFP9. You may have FOR clause in the index and still have it used by Rushmore.