title: Sql XML return check multiple nodes for a value
body: <p>Here is my xml</p>
  
  <pre><code>  &lt;Configuration&gt;
      &lt;Name&gt;EscalatedSubscribers&lt;/Name&gt;
      &lt;Role&gt;Configuration&lt;/Role&gt;
      &lt;UISettings&gt;
        &lt;Control&gt;
         &lt;Name&gt;SubscriberSelector&lt;/Name&gt;
         &lt;Type&gt;Configuration&lt;/Type&gt;
         &lt;DisplayItem&gt;Workspaces&lt;/DisplayItem&gt;
        &lt;/Control&gt;
      &lt;/UISettings&gt;
      &lt;Values&gt;
       &lt;Required&gt;
        &lt;Name Type="WS"&gt;ganderson&lt;/Name&gt;
        &lt;Name Type="WS"&gt;mhoffmann&lt;/Name&gt;
        &lt;Name Type="WS"&gt;lmcswain&lt;/Name&gt;
        &lt;Name Type="WS"&gt;jbranham&lt;/Name&gt;
        &lt;Name Type="WS"&gt;gsimpson&lt;/Name&gt;
        &lt;Name Type="WS"&gt;jbennett&lt;/Name&gt;
        &lt;Name Type="WS"&gt;bdrum&lt;/Name&gt;
        &lt;Name Type="WS"&gt;mtrott&lt;/Name&gt;
        &lt;Name Type="WS"&gt;acannon&lt;/Name&gt;
        &lt;Name Type="WS"&gt;dgantt&lt;/Name&gt;
        &lt;Name Type="WS"&gt;evalone&lt;/Name&gt;
        &lt;Name Type="WS"&gt;flyons&lt;/Name&gt;
        &lt;Name Type="WS"&gt;saheavner&lt;/Name&gt;
      &lt;/Required&gt;
     &lt;/Values&gt;
    &lt;/Configuration&gt;
  </code></pre>
  
  <p>My dataset has an ID, and a name, and the xml field. The goal is to query into the xml for every name, and if the user 'ganderson' is a value of the name node, return that name node.</p>
  
  <pre><code> SELECT p.Tag.query('(/Configuration/Values/Required/*)')
  </code></pre>
  
  <p>return the fulle required node and i am checking if the node is LIKE '%ganderson%'</p>
  
  <pre><code> SELECT p.Tag.value('(/Configuration/Values/Required[1]','varchar(max)') as varchar(max) )
  </code></pre>
  
  <p>returns the first user, which is ganderson, but just because i got lucky. There has to be a more effecient way to do this.</p>