Home > SQL Server, Tips > Using COALESCE to Build Comma-Delimited String directly in SQL

Using COALESCE to Build Comma-Delimited String directly in SQL

October 27th, 2009 Frank Leave a comment Go to comments

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…

Categories: SQL Server, Tips Tags:
FacebookTwitterRSS FeedDeliciousDiggStumbleUpon
  1. No comments yet.
  1. No trackbacks yet.