title: Using .query() in t-sql to get only inner text
body: <p>How can I use the <code>.query()</code> syntax of <code>t-sql</code> to select a specific node, but only get the inner text rather than the inner text wrapped in the node tags?</p>
  
  <p>As in, when I do this:</p>
  
  <pre><code>SELECT TOP 1 [XMLContent].query('/Event/Username'), * from Events
  </code></pre>
  
  <p>I get:</p>
  
  <pre><code>&lt;Username&gt;BURGUNDY&lt;/Username&gt;
  </code></pre>
  
  <p>But what I want is is just <code>BURGUNDY</code>. Obvious I could do some sub strings to get it, but I was hoping there was a quick and easy way to do it. </p>