XML Special characters

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Programming » XML » XML Special characters

XML Special characters

Rate Topic

Display Mode

Topic Options

Author

Message

5409045121009

Posted Sunday, March 17, 2013 3:44 AM

Valued Member

Group: General Forum Members
Last Login: Monday, May 13, 2013 3:43 PM
Points: 56, Visits: 412

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

Post #1431967

5409045121009

Posted Sunday, March 17, 2013 7:13 AM

Valued Member

Group: General Forum Members
Last Login: Monday, May 13, 2013 3:43 PM
Points: 56, Visits: 412

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)')

Post #1431980

« Prev Topic | Next Topic »

Permissions