Josh solved your optimization problem. But, can you have anything else than digits in the ssn field? If not, drop the UPPER().

Vlad

>I am trying to optimize SELECT statement and using function SYS(3054,1) for checking level of optimization.
>
>SELECT ssn FROM employ WHERE UPPER(ssn)="111111111"
>returns 'partial' level of optimization, even I have index on UPPER(ssn). Why and what I'm doing wrong?
>I would like to have 'full' optimization level.
>Thanks in advance.
>Jerry