I can do an update of the table however there are more then 4000 records that contain the -. All of these records need to be modified and the - need to be removed. The character is not always in the same place. I tried doing a replace but that only works for one cell not for all of them.
The content looks like this.
0123-567890 but again the - can also be on a diffrent location. I tried to use translate, replace and update but I wasn't able to get it working.
The table name is customer colum name is telephone number.