Tom,

Put an Ampersand (&), Less than (<) or Greater than (>) in your data, and see what happens with or without it:

WITH CTE (Data) AS

(

SELECT 'Rolling Stones' UNION ALL

SELECT 'Hall & Oates' UNION ALL

SELECT 'One <> Two'

)

SELECT [WithType] = STUFF((

SELECT ',' + Data

FROM CTE

FOR XML PATH(''),TYPE).value('.','varchar(max)'),1,1,''),

[WithOutType] = STUFF((

SELECT ',' + Data

FROM CTE

FOR XML PATH('')),1,1,'');