title: UPDATING a section of string for column
body: <p>We have the following:</p>
  
  <pre><code>create table #a_table 
  (names char(10))
  insert into #a_table
  values
  ('A;B;C;'),
  ('B;C;D;'),
  ('A;B;C;E;'),
  ('A;C;'),
  ('A;B;'),
  ('A;'),
  ('A;C;E;');
  </code></pre>
  
  <p>How do we <code>update</code> the table and change every instance of C; with X;Y;</p>
  
  <p>So<br>
  A;B;C; would become A;B;X;Y;<br>
  A;C;E; would become A;X;Y;E;<br>
  etc.</p>
  
  <hr>
  
  <p><strong>EDIT</strong>  </p>
  
  <p>A standard <code>ANSI</code> approach that is compatible on SQL-server would be prefereable.</p>