title: Replace special character dashes with dashes
body: <p>Just wanted to get advise about this matter from you all. So a lot of our clients do massive imports into the database. Now on one instance the client updated a particular column with around 10000 rows in it. They were trying to add fields ( Sample shown below)</p>
  
  <pre><code>ABC - TEST - TN - ABC D123
  </code></pre>
  
  <p>Now while they were importing all this in the system, the dashes were basically changed into special characters , not sure as to how that happened because when i import the file from the system again it displays funny symbols instead of just a '-' . Now I want to mass update all the data in the columns. I was thinking something like </p>
  
  <pre><code>   UPDATE ABC
     SET columnname = replace(columname,''-'',''-'')
  </code></pre>
  
  <p>Any ideas on this matter would be appreciated. Thank you</p>