Hi Kodamins,
hope to helps:
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 ',' + y
FROM dbo.x FOR XML PATH('')), 1, 1, '');
-- good:
SELECT STUFF((SELECT ',' + y
FROM dbo.x FOR XML PATH, TYPE).value('.[1]',
'nvarchar(max)'), 1, 1, '');
GO
DROP TABLE dbo.x;