Home Forums Programming XML Escaping ampersand in FOR XML RE: Escaping ampersand in FOR XML
Jerry Hung
SSChampion
Points: 12968
More actions
December 12, 2008 at 9:05 am
#911692
I don't know anyway around how to escape/preserve the special characters in XML, since they indeed are SPECIAL
like &, , etc...
http://www.xml.com/pub/a/2001/01/31/qanda.html
Someone asked this question on StackOverflow (Google)
http://stackoverflow.com/questions/270948/how-to-preserve-an-ampersand-while-using-for-xml-path-on-sql-2005