title: Why does SQL display an & as &amp;?
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/1051362/help-with-for-xml-path-escaping-special-characters">help with FOR XML PATH(&#39;&#39;) escaping &ldquo;special&rdquo; characters</a>  </p>
  </blockquote>
  
  
  
  <p>I need some assistance, my query is below:</p>
  
  <pre><code>STUFF(
      (
        SELECT ',' + CountDesc
        FROM Count INNER JOIN ProjectCount ON Count.Id =  ProjectCount.CountId 
        WHERE ProjectCount.ProjectId = Project.Id ORDER BY Count.CountDesc
        FOR XML PATH('')
      ), 1, 1, '') as  [Country]
  </code></pre>
  
  <p>What happens is when i run this query and the Count table has an &amp; in one of its fields, it displays the &amp; as <code>&amp;amp;</code>. </p>
  
  <p>Is there anyway to not let this happen?</p>
  
  <p>Thanks in advance.</p>