title: Update part of String in SQL Server
body: <p>I need to update part of the string in SQL Server. </p>
  
  <p>I have:</p>
  
  <pre><code>ID   IDCityVisited   Names                    
  1    10              Julya,Matheus,Donovan    
  2    15              Mary,Donovan,Richard
  3    20              John,Bob,Andy
  </code></pre>
  
  <p>I need to update the <code>Names</code> column changing only <code>Donovan</code> for <code>Paul</code> and keeping all the remaining string as it is.</p>
  
  <p>Thanks</p>