title: T-SQL Query to replace a symbol or character in one xml node value of XML data type column?
body: <p>I want to replace plus symbol with underscore in the one xml node of a particular table.
  Example: In the below input, i want to replace plus symbol only in filepath node and NOT filename node.
  <strong>Table column data type is XML and NOT varchar.</strong></p>
  
  <p>Input: </p>
  
  <pre><code> &lt;mediadata&gt;
    &lt;image&gt;
      &lt;FileName&gt;BUF2011-450&lt;/FileName&gt;
      &lt;FilePath&gt;/uploadedImages/Products/Indoor_Fun/Puzzles___Brain_Teasers/Puzzles/2000+_Pieces/BUF2011-450.jpg&lt;/FilePath&gt;
      &lt;Thumbnails&gt;
        &lt;Thumbnail&gt;
          &lt;FileName&gt;BUF2011-450&lt;/FileName&gt;
          &lt;FilePath&gt;/uploadedImages/Products/Indoor_Fun/Puzzles___Brain_Teasers/Puzzles/2000+_Pieces/thumb_BUF2011-450_Large.jpg&lt;/FilePath&gt;
        &lt;/Thumbnail&gt;
        &lt;Thumbnail&gt;
          &lt;FileName&gt;BUF2011-450&lt;/FileName&gt;
          &lt;FilePath&gt;/uploadedImages/Products/Indoor_Fun/Puzzles___Brain_Teasers/Puzzles/2000+_Pieces/thumb_BUF2011-450_Small.jpg&lt;/FilePath&gt;
        &lt;/Thumbnail&gt;
      &lt;/Thumbnails&gt;
    &lt;/image&gt;
  &lt;/mediadata&gt;
  </code></pre>