sql update statement replace character code example
Example 1: sql replace character in string in all records
UPDATE employees
SET
phone_number = REPLACE(phone_number, '.', '-');
Example 2: replace string value in sql
UPDATE tableName SET fieldName = REPLACE(fieldName, 'fromStringValue', 'toStringValue');