title: How to extract a value from a csv string and insert it into a column in SQL Server
body: <p>I have the following table in SQL Server:</p>
  
  <pre><code>Value  String (csv)                  Name Color 
  ------------------------------------------------------------------- 
  1      Simi,123456,abc@123,Blue,45   Simi  Dog   
  </code></pre>
  
  <p>I want to extract 'Blue' from the csv string and update the value in the color column.</p>
  
  <pre><code>Value  String                       Name  Color 
  -------------------------------------------------------------------  
  1      Simi,123456,abc@123,Blue,45  Simi  Blue  
  </code></pre>