XML PATH to keep html


I use XML PATH to combine text in SQL, it works well.  But in some text, I have symbols, such as <, >.  After using the XML PATH, it turns into &lt; or &gt;.

Is there a way to keep what it was ?  thanks
Who is Participating?
Dave BaldwinFixer of ProblemsCommented:
Here's the 'Predefined entities in XML' : http://en.wikipedia.org/wiki/List_of_XML_and_HTML_character_entity_references   Most languages have conversion routines to take care of the problem.  This may help: http://forums.asp.net/t/875969.aspx/1
Dave BaldwinFixer of ProblemsCommented:
No, you have to reconvert them because those symbols are also used as tag delimiters in XML.  The basic example from http://www.w3schools.com/xml/default.asp  They are changed into 'entities' so they won't interfere with the XML formatting.

<?xml version="1.0"?>
    <body>Don't forget me this weekend!</body>

Open in new window

mcrmgAuthor Commented:
I see, so basically, I have to use replace function? thanks
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.