REPLACE ​

Replace all occurrences of the search string with the replacement string.

REPLACE(source_string, search_string, replacement_string)

REPLACE(source_string, search_string, replacement_string)

Parameters ​

• source_string - Specifies the string to be searched.
• search_string - Specifies the value to find.
• replacement_string - Specifies the value to use as a replacement.

Examples ​

REPLACE("Hello world!", "world", "Peter")

REPLACE("Hello world!", "world", "Peter")

Result: Hello Peter!

Note: Replace the characters world in the string Hello world! with Peter.