replace(string, search_string, replace_string)

Replace all occurrences of search_string in a string with replace_string. The replacement string can be an empty string. The replace function is faster than regexp_replace for simple cases where a regular expression is not needed.

Examples

str = replace("tree", "ee", "eat")
nospaces = replace("the quick brown fox", " ", "")