replace statement 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, '.', '-');