Example
Replace “T” with “M”:
SELECT REPLACE('SQL Tutorial', 'T', 'M');
Definition and Usage
The REPLACE() function replaces all occurrences of a substring within a string, with a new substring.
Note: The search is case-insensitive.
Tip: Also look at the STUFF() function.
Syntax
REPLACE(string, old_string, new_string)