Skip to main content

Categories: String

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 
SELECT REPLACE('THE CATATONIC CAT', 'CAT', 'DOG')
-- sample return 1