Syntax
SUBSTITUTE(template, old-text, new-text)
Description
SUBSTITUTE() generates a new value from template (of any textual type) by replacing all occurrences of old-text (of any textual type) with new-text (of any textual type).
Return Value
A Text value: the text of template with all occurrences of old-text replaced with new-text.