Replace
Last updated
Last updated
The Replace()
function returns a new text in which all occurences of old_value
in text
are replaced by new_value
.
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Returns a new text where each occurence of old_value
is replaced by new_value
.
Returns Invalid expression
if the result is not a text.
Name | Type | Required | Description |
---|---|---|---|
text
text
the text on which the replace operation is performed.
old_value
text
the text that is to be replaced by new_value
.
new_value
text
the text that replaces all occurrences of old_value
.