title: Replace Single Quote by Double Quote in SQL
body: <p>Can anyone guide me how to replace single Quote by Double Quote in SQL Server....
  I am trying to Search Data (eg: Don't) from SSRS.</p>
  
  <p>It is trowing an error....(Unclosed Quotation mark)</p>
  
  <pre><code> set  @projectDescription = replace (@projectDescription, '''', '')
   print  @projectDescription....
  </code></pre>
  
  <p>Can u pls tell int this scenario...</p>