XML PATH to keep html

Posted on 2012-09-21
Last Modified: 2012-09-21

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
Question by:mcrmg
    LVL 82

    Expert Comment

    by:Dave Baldwin
    No, you have to reconvert them because those symbols are also used as tag delimiters in XML.  The basic example from  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


    Author Comment

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

    Accepted Solution

    Here's the 'Predefined entities in XML' :   Most languages have conversion routines to take care of the problem.  This may help:

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

         When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now