CODE EXAMPLE FOR SQL

sql replace a section of a string in column

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