title: How can I get the Value of one of the add key fields (SQL Server 2012)
body: <p>I am trying to get the Value of one of the add key nodes with an SQL statement.
  Something like </p>
  
  <pre><code>SELECT ColXML from table where value = 'Tom'
  </code></pre>
  
  <p>I only want the row that has this value as the other rows contain the same XML but have different values.
  The table is 
  ID, colXML, Createtime the colXML column is a VARCHAR as well.</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="utf-8"?&gt;
  &lt;appSettings&gt;
       &lt;add key="1" Value="John"&gt;
       &lt;add key="2" Value="Tom"&gt;
       &lt;add key="3" Value="Eric"&gt;
       &lt;add key="4" Value="Jane"&gt;
       &lt;add key="5" Value="Sarra"&gt;
       &lt;add key="6" Value="Suzie"&gt;
       &lt;add key="7" Value="Rick"&gt;
       &lt;add key="8" Value="Jim"&gt;
  &lt;/appSettings&gt;
  </code></pre>