title: from existing value Update column using comma-separated values in SQL Server
body: <p>from existing value Update column using comma-separated values in SQL Server</p>
  
  <pre><code>tbl 
  id name rev_code
  1  aaa  rev1,rev2,rev3
  2  bbb  rev2,rev3
  3  ccc  rev1,rev2
  4  ddd  rev3,rev2
  </code></pre>
  
  <p>i want update where rev_code='rev3' need to add end of with , like rev1,rev2,rev3,rev5</p>
  
  <p>expecting output</p>
  
  <pre><code>id name rev_code
  1  aaa  rev1,rev2,rev3,rev5
  2  bbb  rev2,rev3,rev5
  3  ccc  rev1,rev2
  4  ddd  rev3,rev2,rev5
  </code></pre>