Update(Replace partcial value) XML Column in SQL
<p>I have an XML column in my Table and i wanted to replace particular text wherever it appear in that column with a new text. Here is the xml structure,</p>

<pre><code>&lt;Story&gt;
 &lt;StoryNonText&gt;
  &lt;NonText&gt;
   &lt;ImageID&gt;1&lt;/ImageID&gt;
   &lt;Src&gt;http://staging.xyz.com/FolderName/1.png&lt;/Src&gt;
  &lt;/NonText&gt;
  &lt;NonText&gt;
   &lt;ImageID&gt;2&lt;/ImageID&gt;
   &lt;Src&gt;http://staging.xyz.com/FolderName/2.png&lt;/Src&gt;
  &lt;/NonText&gt;
 &lt;/StoryNonText&gt;
&lt;/Story&gt; 
</code></pre>

<p>In the above XML I wanted to replace all the <code>&lt;Src&gt;</code> values having <strong><a href="http://staging.xyz.com/" rel="nofollow">http://staging.xyz.com/</a></strong> to <strong><a href="http://production.xyz.com/" rel="nofollow">http://production.xyz.com/</a></strong>. Please guide me how i can do this!</p>