>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.
Erik Moore
Clientelligence