- Categories:
String & Binary Functions (General)
TRANSLATE¶
Translates subject
from the characters in sourceAlphabet
to the
characters in targetAlphabet
.
Syntax¶
TRANSLATE( <subject>, <sourceAlphabet>, <targetAlphabet> )
Arguments¶
subject
A string expression that is translated. If a character in subject is not contained in
sourceAlphabet
, the character is added to the result without any translation.sourceAlphabet
A string with all characters that are modified by this function. Each character is either translated to the corresponding character in the
targetAlphabet
or omitted in the result if thetargetAlphabet
has no corresponding character (i.e. has less characters than thesourceAlphabet
).targetAlphabet
A string with all characters that are used to replace characters from the
sourceAlphabet
.
Collation Details¶
Arguments with collation specifications are currently not supported.
Examples¶
Translate ‘X’ to ‘c’, ‘Y’ to ‘e’, ‘Z’ to ‘f’ and remove ‘❄’ characters:
SELECT TRANSLATE('❄a❄bX❄dYZ❄','XYZ❄','cef');
--------------------------------------+
TRANSLATE('❄A❄BX❄DYZ❄','XYZ❄','CEF') |
--------------------------------------+
abcdef |
--------------------------------------+