Hi Mel:

>

>TRIM(UPPER(last))+" "+TRIM(UPPER(first))
>

You want to take the above expression and then pad it out to a fixed length, like so :-

Padr(TRIM(UPPER(last))+" "+TRIM(UPPER(first)),30)   && Or whatever length value is appropriate

This will *really* help the index from an optimisation perspective.

Given that you are upper case, you need to type the value into the Find box in uppercase too.

HTH