title: Get value of XML node with condition using SQL server
body: <p>I have not worked with XML in the database before so I need some help.
  I need to get the value where name equals "sv-SE" from the XML for a number of rows.</p>
  
  <p>XML looks like this:<br>
  Row 1</p>
  
  <pre><code>&lt;cultures&gt;
    &lt;culture name="sv-SE"&gt;Sverige&lt;/culture&gt;
    &lt;culture name="en-GB"&gt;Sweden&lt;/culture&gt;
  &lt;/cultures&gt;
  </code></pre>
  
  <p>Row 2</p>
  
  <pre><code>&lt;cultures&gt;
    &lt;culture name="sv-SE"&gt;Norge&lt;/culture&gt;
    &lt;culture name="en-GB"&gt;Norway&lt;/culture&gt;
  &lt;/cultures&gt;
  </code></pre>
  
  <p>Expected output from this query would be</p>
  
  <pre><code>Sverige
  Norge
  </code></pre>
  
  <p>When the name is "sv-SE"</p>
  
  <pre><code>select tblCountry.name.?? --XmlColumn
  from tblCountry
  </code></pre>