title: Removing special characters in sql
body: <p>I am new to SQL and just know basic insert, update, and delete syntax.</p>
  
  <p>I have an excel file, that I imported into the SQL server, but somehow, it brought in weird symbols and characters.</p>
  
  <p>When I checked the excel file ,cleared all formatting, and re-uploaded, it would still show up, not sure how to clean it up.</p>
  
  <p>Is there an easy replace syntax that you can suggest for me to use to do a global cleanup?</p>
  
  <p>Sample values inside the columns are:</p>
  
  <pre><code>Lisa┬áHettinger┬á┬áCherry┬áCreek┬áProp
  Lisa┬áJ┬áHernandez
  </code></pre>
  
  <p>I would need to remove the weird <code>┬</code> and <code>á</code> characters.</p>