How to concatenate text from multiple rows into a single text string in SQL Server
Asked 07 September, 2021
Viewed 890 times
  • 67
Votes

Consider a database table holding names, with three rows:

Peter
Paul
Mary

Is there an easy way to turn this into a single string of Peter, Paul, Mary?

30 Answer