REPLACE

Use REPLACE to substitute a string for another. The first parameter is the string expression. The second parameter is the original string to search. The third parameter is the replacement string.

REPLACE(string_expression, search_string, substitute_string)