title: How to remove double quotes within a column in SQL server 2012
body: <p>I need to remove double quotes within a column value. For example, I have a column in table which has values as below</p>
  
  <ol>
  <li>"Testing Name ("Inc")"</li>
  <li>"Testing, "Trust" ("Inc")" </li>
  </ol>
  
  <p>I need to remove the double quotes surrounding the "Inc" &amp; "Trust" and column values should resemble as below</p>
  
  <ol>
  <li>"Testing Name (Inc)"</li>
  <li>"Testing, Trust (Inc)" </li>
  </ol>
  
  <p>I tried with REPLACE() function. But it replaces all the double quotes in a value. But I want to retain the quotes at start and end of the value. Kindly help</p>