Umm, you might want to change your description. The COALESCE function built into SQL Server does not create a concatenated string out of a list of values. From BOL:

COALESCE

Returns the first nonnull expression among its arguments.

If you're referring to a COALESCE UDF, you might want to try to point the user to that function as well.

Just FYI - presumably, I'm the only one of the hundreds of people who read this who's anal-retentive enough to bring it up....