TRANSLATE

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..'.