By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE dbo.x(y nvarchar(255));
INSERT dbo.x SELECT 'Sports & Recreation'
UNION ALL SELECT 'x >= y'
UNION ALL SELECT 'blat'
UNION ALL SELECT '<hooah>';
-- BAD:
SELECT STUFF((SELECT N',' + y
FROM dbo.x
FOR XML PATH(N'')),1, 1, N'');
-- GOOD:
SELECT STUFF((SELECT N',' + y
FROM dbo.x
FOR XML PATH, TYPE).value(N'.[1]', N'nvarchar(max)'),1, 1, N'');
-- BEST:
SELECT STRING_AGG(y, N',') FROM dbo.x;
| (No column name) |
|---|
| Sports & Recreation,x >= y,blat,<hooah> |
| (No column name) |
|---|
| Sports & Recreation,x >= y,blat,<hooah> |
| (No column name) |
|---|
| Sports & Recreation,x >= y,blat,<hooah> |