Translates one or more characters of the first argument. There can be up to four arguments, but only the first is required.
The first argument must be a character string or UCS-2 graphic string. The second argument defines the to-string. The third argument defines the from-string. The fourth argument is a character constant of length 1 that is used to pad the to-string if it is shorter than the from-string.
Example:
Given that column SITE has a value of 'Pivabiska Lake Place'.
TRANSLATE(SITE, '$', 'L')
Returns the value 'Pivabiska $ake Place'.
TRANSLATE(SITE, '$$', 'Ll')
Returns the value 'Pivabiska $ake P$ace'.
TRANSLATE(SITE, 'pLA', 'Place', '.')
Returns the value 'pivAbiskA LAk. pLA..'.