TRANSLATE
Syntax
TRANSLATE(<expr>, <source>, <dest>)
Description
Converts any characters from <source> in
<expr> to the corresponding character in
<dest>, ie.
TRANSLATE("ABCD","BC","CB") = "ACBD"
If there is no corresponding character in
<dest> then the character is left unchanged.