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)

```
ABC - TEST - TN - ABC D123

```

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 

```
   UPDATE ABC
   SET columnname = replace(columname,''-'',''-'')

```

Any ideas on this matter would be appreciated. Thank you