title: How can I remove leading and trailing quotes in SQL Server?
body: <p>I have a table in a SQL Server database with an NTEXT column.  This column may contain data that is enclosed with double quotes. When I query for this column, I want to remove these leading and trailing quotes.  </p>
  
  <p>For example:</p>
  
  <p><em>"this is a test message"</em></p>
  
  <p>should become</p>
  
  <p><em>this is a test message</em></p>
  
  <p>I know of the LTRIM and RTRIM functions but these workl only for spaces.  Any suggestions on which functions I can use to achieve this.</p>