Get All rows into One String May 13, 2011 by Webhead This is an easy way to get all rows from a SQL table into a string: select stuff(( select ', ' + a_column from [name_of_table] order by table_id for xml path('') ), 1, 1, '')