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.