Removing XML tags from FOR XML PATH
<p>I am getting data from a sql string to make an XML file, here is my SQL</p>

<pre><code>SELECT [data] AS data
FROM MyTable 
WHERE [Status] = '1' 
FOR XML PATH('DataLocation')
</code></pre>

<p>And here is my XML return</p>

<pre><code>&lt;DataLocation&gt;
  &lt;data&gt;String&lt;/data&gt;
&lt;/DataLocation&gt;
</code></pre>

<p>The problem I have is I want to have the tags <code>DataLocation</code> but not the tag <code>data</code>, I just want to show the <code>String</code> value.</p>

<p>Where am I going wrong?</p>