Answered by : coding-cobra

UPDATE employees
SET phone_number = REPLACE(phone_number, '.', '-');

Source : https://www.sqltutorial.org/sql-string-functions/sql-replace/ | Last Update : Mon, 13 Jul 20

Answered by : ahren-adams

SELECT REPLACE( phone, '-', ' ' ) as new_phone
FROM investor;

Source : https://learnsql.com/cookbook/how-to-replace-part-of-a-string-in-sql/ | Last Update : Sat, 19 Nov 22