I didn't believe there was anything else in the statement that was pertinent to the question that I didn't already post, but then I remembered this does use macro substitution. I'll have to test to see if that makes a difference.

WhereClause = "right(PrSSNum,4) = '1234'"
select PrEmpl, PrFirst, PrLast, PrSSNum, PrDept, PrDOH;
   from PrEmpl;
   where &WhereClause;
   into cursor SearchTempCursor readwrite

I had indicated my version (VFP 9 SP 1), but I did a preview of the post. If you do that and then submit it, it loses the settings for version, database, etc. Kind of an irritating problem that I mentioned to Michel, but one that he said would be fixed when they moved completely to ASPX for the site and would not fix in the current version.


>Can you post the whole statement? Which VFP version/SP you're using? Can you also post Rushmore results?
>
>>If I create an index on the last four digits on the SSN field . . .
>>
>>

>>index on right(SSN,4) tag Last4SSN
>>

>>
>>and I have a query that has a where clause like so . . .
>>
>>

>>where right(SSN,4) = "1234"
>>

>>
>>then the way I understand it - and the way the help system seems to indicate - the query is Rushmore optimizable. Yet when I check for the optimization level, it says "none".
>>
>>What am I missing? Am I misreading the docs or are they lying to me?
>>
>>Russell Campbell