REPLACE(string_exp1, string_exp2, string_exp3)

Search string_exp1 for occurrences of string_exp2 and replace with string_exp3.

 

Example:

SELECT REPLACE('ABCDE','CDE','FG') returns ABFG