title: SQL Server XML output with CDATA
body: <p>Is there a way to have an SQL Server XML return use CDATA? I have XML being returned by SQL Server like this:</p>
  
  <pre><code>&lt;locations&gt;
      &lt;site id="124"&gt;
          &lt;sitename&gt;Texas A &amp;amp; M&lt;/sitename&gt;
      &lt;/site&gt;
  &lt;/locations&gt;
  </code></pre>
  
  <p>When I am required to have this:</p>
  
  <pre><code>&lt;locations&gt;
      &lt;site id="124"&gt;
          &lt;sitename&gt;&lt;![CDATA[Texas A &amp; M]]&gt;&lt;/sitename&gt;
      &lt;/site&gt;
  &lt;/locations&gt;
  </code></pre>