>>>>Never thought about that one. Maybe padr(alltrim(somefield), 40, " ") would keep the field at a reliable width of 40 or whatever number you select, thus avoiding the problem?
>>>
>>>Suppose that would work. Really the only thing I can think of that would require an ALLTRIM is the concatenation of two or more fields. Then the PADR solution would fit the bill.
>>
>>And in that particular case, you're probably better off concatenating with the - operator, which moves the trailing blanks of the first argument to the end of the concatenation.
>
>Right. But the usual case for concatenation fom my experience is stuff like:
>
>ALLTRIM(fname) + " " + mi + ". " + ALLTRIM(lname)
>
>However, I have gotten out of the habit of doing this in the query, and just doing it in the report or whatever I am building the query or view for.
Yes, that's where exact concatenation with ALLTRIM() is needed (BTW, there's a problem with that example for formatting people with no middle initial!), but I rarely need to use that in an index or SQL select statement (ordinarily, it's only significant when formatting output. I'm sure there are circumstances where it's necessary for people to do this; I'm just thankful that i can avoid it nearly all the time...
Ed