TRANSLATE

​

Syntax

​

Scalar

translate(value, from, to)

​

Arguments

​

Returns

• Type: STRING
• Possible values: The translated string.
• NULL behavior: Returns NULL if any argument is NULL.

​

Properties

​

Usage notes

• A from character without a corresponding to character is deleted.
• If from contains duplicates, the first occurrence supplies the mapping.
• Characters absent from from are retained.

​

Examples

​

Typical behavior

SELECT translate('12345', '143', 'ax') AS "value";

​

Remove characters without a replacement

SELECT translate('abcabc', 'bc', 'X') AS translated;