title: Find and replace just a part of a xml value using XQuery?
body: <p>I have an XML in one of my columns, that is looking something like this:</p>
  
  <pre><code>&lt;BenutzerEinstellungen&gt;
         &lt;State&gt;Original&lt;/State&gt;
         &lt;VorlagenHistorie&gt;/path/path3/test123/file.doc&lt;/VorlagenHistorie&gt;
         &lt;VorlagenHistorie&gt;/path/path21/anothertest/second.doc&lt;/VorlagenHistorie&gt;
         &lt;VorlagenHistorie&gt;/path/path15/test123/file.doc&lt;/VorlagenHistorie&gt;
  &lt;/BenutzerEinstellungen&gt;
  </code></pre>
  
  <p>I would like to replace <strong>all</strong> <code>test123</code> occurances (there can be more than one) in <code>VorlagenHistorie</code> with <code>another test</code>, that all paths direct to test123 after my update.</p>
  
  <p>I know, how you can check and replace all values with an equality-operator, I saw it in this answer: 
  <a href="https://stackoverflow.com/questions/15435485/dynamically-replacing-the-value-of-a-node-in-xml-dml">Dynamically replacing the value of a node in XML DML</a></p>
  
  <p>But is there a CONTAINS Operator and is it possible to replace INSIDE of a value, I mean only replace a part of the value?</p>
  
  <p>Thanks in advance!</p>