<div>
No, you have to reconvert them because those symbols are also used as tag delimiters in XML. &nbsp;The basic example from <a href="http://www.w3schools.com/xml/default.asp" rel="ugc">http://www.w3schools.com/xml/default.asp</a>&nbsp; They are changed into 'entities' so they won't interfere with the XML formatting.<br />
<br />

<pre><code id="code-20-38423486-1">&lt;?xml version=&quot;1.0&quot;?&gt;
&lt;note&gt;
    &lt;to&gt;Tove&lt;/to&gt;
    &lt;from&gt;Jani&lt;/from&gt;
    &lt;heading&gt;Reminder&lt;/heading&gt;
    &lt;body&gt;Don't forget me this weekend!&lt;/body&gt;
&lt;/note&gt;</code></pre>
</div>


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 [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"?>
<note>
    <to>Tove</to>
    <from>Jani</from>
    <heading>Reminder</heading>
    <body>Don't forget me this weekend!</body>
</note>

<div>
I see, so basically, I have to use replace function? thanks
</div>


I see, so basically, I have to use replace function? thanks

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I use XML PATH to combine text in SQL, it works well. &nbsp;But in some text, I have symbols, such as &lt;, &gt;. &nbsp;After using the XML PATH, it turns into &amp;lt; or &amp;gt;.<br />
<br />
Is there a way to keep what it was ? &nbsp;thanks
</div>
</div>


Hi,

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

XML PATH to keep html

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.