>>you should reduce spaces to just one space.
>>
>>Actually, I have an application written, where I dealt with lots of different name formats to transform them into our standard. It was quite complicated algorithm...
>
>
>Oh, I see. But if I keep (and I do) FirstName in one field and LastName in another I will build the result string like this:
>abc = ALLTRIM(FirstName) + ' ' + ALLTRIM(LastName)
>
>Mark
He-he. You want to make it simpler, than it is ) Anyway, my point is, that there is a function, which could be used, and we don't need to create our own algorithm, since it already exists. I think, most of us would still create our own algorithm instead... :)
If it's not broken, fix it until it is.
My Blog