TRANSLATE(string[,[tableo][,[tablei][,pad]]])

This function translates characters in string to other characters, or
may be used to change the order of characters in a string.
If neither translate table is specified, then the string is translated
into uppercase. Otherwise each character of string which is found in
tablei is translated into the corresponding character in tableo -
characters which are not found in tablei remain unchanged. The default
input table is XRANGE('00'x,'ff'x) and the default output table is the
null string. The output table is padded or truncated in order to make
it the same length as the input table, the default pad character being
a blank.
Examples:
   translate('abc123DEF')              == 'ABC123DEF'
   translate('abbc','&','b')           == 'a&&c'
   translate('abcdef','12','ec')       == 'ab2d1f'
   translate('abcdef','12','abcd','.') == '12..ef'
   translate('4123','abcd','1234')     == 'dabc'