Use of COALESCE to create comma separated list

Suppose we have following data in Employee table and we need to make a semicolon separated list of EmailIDs to send mail, then we can use COALESCE as shown in below fig.
Here I am creating a semicolon(;) separated list. You can use comma(,) in place of semicolon to make comma separated list.


Summary
In this article I expose the use of COALESCE to make comma separated or deli-meter separated list.

Thanks.
I would like to have feedback from my blog readers. Please post your feedback, question, or comments about this article.