>>No, ALLTRIM() doesn't touch blanks in the middle
>
>I was talking about where the first and last name are different fields. Sorry I wasn't clear.
>
>>and sometimes it might be used if user wants to have sorting by last (w/out trailing spaces)+first name.
>
>My example showed that this is usually not what is desired. You generally would want Tim James to come before Alan Jameson.

Alltrim(Last)+space(1)+Alltrim(First)