title: Replace value in XML using SQL
body: <p>I need to replace a value in xml using SQL, challenge here I am facing is the value which I want to replace is not on a specific xpath, same value is on different nodes and the xpath is also different, so basically I want to find and replace a value.</p>
  
  <p>example:</p>
  
  <pre class="lang-xml prettyprint-override"><code>&lt;data&gt;
    &lt;policy&gt;
      &lt;Effectivedate&gt;2018-04-05&lt;/Effectivedate&gt;
      &lt;TermStartDate&gt;2018-04-05&lt;/TermStartDate&gt;
      &lt;Line&gt;
          &lt;Risk&gt;
              &lt;Coverage&gt;
                  &lt;Type&gt;1&lt;/Type&gt;
                  &lt;coverstartdate&gt;2018-04-05&lt;/coverstartdate&gt;
              &lt;/Coverage&gt;
              &lt;Coverage&gt;
                  &lt;Type&gt;2&lt;/Type&gt;
                  &lt;coverstartdate&gt;2018-04-05&lt;/coverstartdate&gt;
              &lt;/Coverage&gt;
              &lt;Coverage&gt;
                  &lt;Type&gt;3&lt;/Type&gt;
                  &lt;coverstartdate&gt;2018-04-05&lt;/coverstartdate&gt;
              &lt;/Coverage&gt;
          &lt;/Risk&gt;
      &lt;/Line&gt;
    &lt;/policy&gt;
   &lt;/data&gt;
  </code></pre>
  
  <p>In above example I need to replace date 2018-04-05 with 2018-04-06</p>
  
  <p>Please can anyone help here.</p>