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.