# Friday, October 21, 2005
Creating a Comma-Delimited String from a Single-Column Query

Garth Wells has posted a sweet trick in MSSQL Syntax for creating a comma-delimited string from a single column query using only a single SELECT statement.  He uses COALESCE and what I'd call "SELECT-embedded variable concatenation" to work a clever and concise solution.

MS SQL | Transact-SQL
Friday, October 21, 2005 12:33:09 PM (Central Daylight Time, UTC-05:00)  #    Disclaimer  |  Comments [0]  |  Related posts:
How to Compare / Test the Equality of two Queries in SQL Server with SQL
Use a Common Table Expression along with ROW_NUMBER() to Paginate Records in your SQL Server queries
.NET helper method to convert a SQL Query to CSV (comma separated value) format for output to file, HttpResponse, console, etc.
SQL Server 2000/2005 function to calculate distance in miles between 2 latitude/longitude points for zip radius search, etc.
Making dynamic text form fields storage easier using .Net
Cross Tab (Row to Column) Generator - MSSQL Stored Procedure
All comments require the approval of the site owner before being displayed.
Name
E-mail
(will show your gravatar icon)
Home page

Comment (Some html is allowed: b, blockquote@cite, em, i, strike, strong, sub, sup, u) where the @ means "attribute." For example, you can use <a href="" title=""> or <blockquote cite="Scott">.  

Enter the code shown (prevents robots):
Live Comment Preview