title: Update, find/replace for xml field
body: <p>I have a Page table in my database.
  Lets say for simplicity it has two columns; title and xmlData
  It has Title something like "my example "
  and I have a xml field that looks like:</p>
  
  <pre><code>&lt;MA&gt;
    &lt;A&gt;
      &lt;URL&gt;my-example-&lt;/URL&gt;
      &lt;id&gt;5&lt;/id&gt;
      &lt;/A&gt;
  &lt;/MA&gt;
  </code></pre>
  
  <ol>
  <li><p>I am trying to do a find replace of any url that has "-" at the end, and remove the only the last trailing "-" if it exists</p></li>
  <li><p>and remove the trailing space(if it has one, to title)</p></li>
  </ol>
  
  <p>I am able to grab the rows that need to be changed by doing</p>
  
  <pre><code>select * from Pages
  where title like '% '
  </code></pre>
  
  <p>(there is some joins and stuff, but that is basically it)</p>