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