>I know how to join two string fields using -'-'-
>
>Is there a similar sequence for joining two fields with a single space instead of a dash, or a comma and a space?
>
>Example: mike bollinger or bollinger, mike
>
>I tried lastname-', '-firstname BUT it displayed bollinger,mike (no space)
That's because "-" trims trailing spaces. Try
lastName - ", " + firstName
(or
RTRIM(firstName)
)
or, to be more elaborate,
ALLTRIM(lastName) + ", " + ALLTRIM(firstName)