replaces all occurrences of the specified pattern in the text with a new pattern.
attribute of Plain Text type or expression producing Plain Text, the pattern to be replaced and the pattern to replace with.
REPLACE_PATTERN('John Smith', 'Smith', 'Black') returns 'John Black'