Description of the TRANSLATE statement

Each translation list entry contains a compare value and a replacement value pair. Each translation list compare value is assessed in turn. When a match is found, the replacement value is placed into the receiving variable (which is identified by name) and translation stops. If no match is found, the receiving variable is assigned a null value.

To ensure that a match is found in the translation list, you can create an entry in which the compare value is the same as the compare string.

Compare string, compare value, and replacement value parameters can be literals, variables, or concatenations of both.