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
If it's not broken, fix it until it is.
My Blog