>>>
>>>That's because "-" trims trailing spaces. Try
>>
>>Is this correct? I thought "-" moved the spaces to the end rather than trimming them.
>>
>>
>>
>>>
>>>
lastName - ", " + firstName
(or
RTRIM(firstName)
)
>>>
>>
>>If LastName has trailing blanks I got
>>LLLLLL, FFFFFF
>
>I'm virtually ignorant of HTML and didn't realize the extra blanks would get trimmed out of my reply. It should have been
>
>LLLLLL,BBBBBBFFFFFF
>
>where "B" represents a blank
Frankly, the real solution would be
lastName - (", " + firstName)
- simply because in the first example it moved only the comma and its accompanying space to the location of the first trailing space in the last name. With the parentheses, the whole expression gets moved to the end.
The spaces are not trimmed - just moved to the end.