TRANSLATE function - Documentation for BMC AMI Command Center for Db2 12.1

If only string expression is specified, the translate function is treated as an UPPER function.

If the argument can be null, the result can be null; if the argument value is null, the result is the null value.

TRANSLATE searches tablei for each character in stringExpression. If it finds the character, the corresponding character in tableo is used in the result string; if tablei contains duplicates, TRANSLATE uses the first (leftmost) occurrence . If it does not find the character, then TRANSLATE uses the original character in string. The result string is always the same length as string.

You Might Also Like