Returns the String indicated in the @text parameter with all occurrences of the @pattern parameter replaced by the @replacement parameter.

Syntax

REPLACE(@text, @pattern, @replacement)

Parameters

•@text: String from which the replacements must be performed

•@pattern: Pattern to replace in @text

•@replacement: Value that replaces @pattern