On this page

    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

    SELECT REPLACE('THE CATATONIC CAT', 'CAT', 'DOG')
    -- sample return 1