On this page

    Categories: String


    Translates the base expression from the source characters/expression to the target characters/expression.


    TRANSLATE(base_expression varchar, source_characters varchar, target_characters varchar) → varchar

    • base_expression: The string to translate.
    • source_characters: A string with all the characters in the base expression that need translating. Each character in this string will be replaced with the corresponding character from the target_characters expression or ommitted from the string if target_characters expression has less characters than the source_characters.
    • target_characters: A string containing all the characters to replace the original characters with.


    TRANSLATE example
    SELECT TRANSLATE('*a*bX*dYZ*','XYZ*','cef');
    -- abcdef