OK, in that case you want ALLT on the search expression but not as part of the index expression. You can index on UPPER(lastname) and SEEK ALLT(UPPER(m.lastname)) just fine.


>
>I wanted the alltrim because the search expression is entered by the user. It is possible that the user will enter leading or trailing blanks.
>
>I'm thinking I might try just a LRTIM on the search expression then pad the field to match the key. That should do it. However, I'll still maintain the UPPER().
>
>Charlie