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


>or, to be more elaborate,
>
>ALLTRIM(lastName) + ", " + ALLTRIM(firstName)

This looks like the best bet