FOR XML problem

[Fursten]

Executing a FOR XML clause into SQL Server 2000, returns XML. However all the characters ">" and "<" are represented with codes like "&lt;" and "&gt;". If I then try to load this XML with Microsoft parser (xml.xmldocument.loadXML(), for instance), I will receive an error. IT seems the parser doesn´t know how to interpret those characters.

What can be done?

Thank you.

 

[bhuninghake]

Have you tried using the replace command on your asp ?

 replace(yourString,"&lt;","<")
 replace(yourString,"&gt;",">")

 

[Fursten]

Hi,

I made something like that, however, I think it must exist one simple way of doing that. if XML works with those characters, any class that works with XML shoul interpret that correctly...

Thank you