Gary,

>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.
>

Still no match. I have a name I type in of MILLER BILL and it still does not find it. Do I need to do something special to tell the Find Dialog I am searching on two fields?

Actually upon closer checking, the above will not even find it if I only type in the last name of MILLER.

Mel Cummings