XML Special characters

• lwe@xtra.co.nz

  Mr or Mrs. 500

  Points: 554

  More actions

  March 17, 2013 at 3:44 am

  #100873

  DECLARE @t TABLE(a VARCHAR(100))

  INSERT @t SELECT 'abc' UNION ALL SELECT 'd<c>f' UNION ALL SELECT 'ghi'

  SELECT

  CAST(

  (SELECT a+',' FROM @t FOR XML PATH('')) AS XML

  ).query('/.[1]').value('.','nvarchar(200)')

  Would like to see abc,d<c>f,ghi as output

  Not abc, d & l t ; c & g t ; f,ghi,

  Thanks

• lwe@xtra.co.nz

  Mr or Mrs. 500

  Points: 554

  More actions

  March 17, 2013 at 7:13 am

  #1597878

  My fault, actually working correctly.

  DECLARE @t TABLE(a VARCHAR(100))

  INSERT @t SELECT 'abc' UNION ALL SELECT 'd<c>f' UNION ALL SELECT 'ghi' UNION ALL SELECT '<">'

  SELECT

  CAST(

  (SELECT a+',' FROM @t FOR XML PATH('')) AS XML

  ).query('/.[1]').value('.','nvarchar(200)')