title: XML Node Update with Where Clause
body: <p>I have a Table with a XML Column. Below is the Sample Data of the XML Column</p>
  
  <pre><code>         &lt;ColItem&gt;
               &lt;Item&gt;
                  &lt;Name&gt;ItemA&lt;/Name&gt;
                  &lt;Price&gt;100&lt;/Price&gt;
               &lt;/Item&gt;
               &lt;Item&gt;
                  &lt;Name&gt;ItemB&lt;/Name&gt;
                  &lt;Price&gt;200&lt;/Price&gt;
               &lt;/Item&gt;
               &lt;Item&gt;
                  &lt;Name&gt;ItemC&lt;/Name&gt;
                  &lt;Price&gt;300&lt;/Price&gt;
               &lt;/Item&gt;
          &lt;/ColItem&gt;
  </code></pre>
  
  <p>I want to Update 'ItemA' with 'ItemNewA' in the  Node. This should be checked and updated for all rows which has the Item 'ItemA'.</p>
  
  <h2>Pseudo Query</h2>
  
  <p>Update Tbl
  Set XmlCol.Modify('ItemA') with 'ItemNewA'
  Where XMLCol.Has('ItemA')</p>
  
  <p>What should be the actual query to achive this in SQL Server.</p>