title: SQL STUFF() function keeps escaping my HTML
body: <p>Using the tutorial here:</p>
  
  <p><a href="http://www.sqlservercurry.com/2008/06/combine-multiple-rows-into-one-row.html" rel="nofollow">http://www.sqlservercurry.com/2008/06/combine-multiple-rows-into-one-row.html</a></p>
  
  <p>I wrote the following query:</p>
  
  <pre><code>SELECT DISTINCT STUFF( (SELECT '&lt;li&gt;' + CountryCode + '&lt;/li&gt;' from Country  FOR XML PATH('')),1,1,'') as Codes FROM Country
  </code></pre>
  
  <p>This works great, but all my HTML is now encoded (i.e. <code>&amp;lt;li&amp;gt;</code>)</p>
  
  <p>Is there a way around this?  Using a SUBSTRING() approach does this also.</p>