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