REPLACE
Removes all occurrences of a specified substring and replaces them with another string.
Syntax
REPLACE(string_expression varchar, pattern varchar, replacement varchar) → varchar
string_expression: String expression in which to do the replacements.
pattern: The substring you want replaced in the string_expression.
replacement: The string to replace the occurrences of the pattern substring with.
Examples
REPLACE example
Last updated