>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 appropriateThis will *really* help the index from an optimisation perspective.