Concatenating Column Values into a Comma-Separated List

by 
SELECT LEFT(Car, LEN(Car) - 1)
FROM (
    SELECT Car + ', '
    FROM Cars
    FOR XML PATH ('')
  ) c (Car)

More Related Contents:

  1. SQL Server – error when creating stored procedure
  2. How can foreign key constraints be temporarily disabled using T-SQL?
  3. Does T-SQL have an aggregate function to concatenate strings? [duplicate]
  4. Datatype for storing ip address in SQL Server
  5. Is there a way to loop through a table variable in TSQL without using a cursor?
  6. Maximum size of a varchar(max) variable
  7. best way to convert and validate a date string
  8. How to get a date in YYYY-MM-DD format from a TSQL datetime field?
  9. How do I format a number with commas in T-SQL?
  10. How to set a default value for an existing column
  11. Need a datetime column in SQL Server that automatically updates when the record is modified
  12. SQL Server: combining multiple rows into one row
  13. How do I find a stored procedure containing ?
  14. SQL Server: Index columns used in like?
  15. SQL Server error on update command – “A severe error occurred on the current command”
  16. Recursive sum in tree structure
  17. SQL server schema and default schema
  18. Get ROWS as COLUMNS (SQL Server dynamic PIVOT query)
  19. SQL Server 2008 – How do i return a User-Defined Table Type from a Table-Valued Function?
  20. Check if a string contains a substring in SQL Server 2005, using a stored procedure
  21. FOR XML PATH(”): Escaping “special” characters
  22. Cannot bulk load. Operating system error code 5 (Access is denied.)
  23. Instead of trigger in SQL Server loses SCOPE_IDENTITY?
  24. Does query plan optimizer works well with joined/filtered table-valued functions?
  25. SQL Server error “Implicit conversion of because the collation of the value is unresolved due to a collation conflict.”
  26. SQL SERVER – Understanding how MIN(text) works
  27. Pivot multiple columns based on one column in SQL Server
  28. @@ERROR and/or TRY – CATCH
  29. How to calculate difference in hours (decimal) between two dates in SQL Server?
  30. Cannot delete rows from a temporal history table

Leave a Comment