title: How do I avoid character encoding when using "FOR XML PATH"?
body: <p>I'm looking to create a comma-separated list of values from a SQL Server 2005 table, just like in <a href="https://stackoverflow.com/q/12435284/1383298">JanetOhara's question</a>.  I'm using a query similar to the one presented in <a href="https://stackoverflow.com/a/12435331/1383298">techdo's answer</a> to the question.</p>
  
  <p>Everything is working, except the list of values is getting XML encoded.  What should be:</p>
  
  <pre><code>Sports &amp; Recreation,x &gt;= y
  </code></pre>
  
  <p>Is instead returning as:</p>
  
  <pre><code>Sports &amp;amp; Recreation,x &amp;lt;= y
  </code></pre>
  
  <p>Is there a way to disable the XML character encoding when using "FOR XML" in SQL Server?</p>