Using COALESCE to Build Comma-Delimited String directly in SQL
The following article covers a great should-know piece of information for any SQL Server developer. Though, comma delimited strings are not usually desired in database, it can be nice to receive data this way for things like embedding in to a query string or passing over a web service*.
http://www.sqlteam.com/article/using-coalesce-to-build-comma-delimited-string
*I don’t necessarily suggest the web service idea. I was just saying for illustrative purposes…






