REPLACE

Replace occurrences of substring.

Category: String Functions

Syntax

REPLACE(str, search, replacement)

Arguments

• str varchar Input string value.
• search varchar Text or pattern to replace in the input.
• replacement varchar Replacement text used for matched content.

Returns

varchar — Returns the computed result as varchar.