title: Remove special char using select statement SQL
body: <p>Right now I am using the following query to update (remove) the existing sql char</p>
  
  <pre><code>UPDATE tblCompany
  SET CompanyName = replace(CompanyName , '''', '')
  </code></pre>
  
  <p>is there anyway when I try to strip those spl char when I use select statment ?</p>
  
  <p>like </p>
  
  <pre><code>Select ID,CompanyName(replace(CompanyName , '''', '')) from tblcompany
  </code></pre>