search for a character and replace it in varchar column sql code example
Example: sql replace character in string in all records
UPDATE employees
SET
phone_number = REPLACE(phone_number, '.', '-');
UPDATE employees
SET
phone_number = REPLACE(phone_number, '.', '-');