The TRANSLATE( ) function can be used to assign any result data to any input data. Up to ten translation operations can be specified; WHEN and THEN clauses must be present in pairs.
Result type: STRING
TRANSLATE( ) |
STRING = string_expression0 ,WHEN1 = *NONE / string_expression1, THEN1 = *NONE / *SAME / string_expression11 ,WHEN2 = *NONE / string_expression2, THEN2 = *NONE / *SAME / string_expression12 ,WHEN3 = *NONE / string_expression3, THEN3 = *NONE / *SAME / string_expression13 ,WHEN4 = *NONE / string_expression4, THEN4 = *NONE / *SAME / string_expression14 ,WHEN5 = *NONE / string_expression5, THEN5 = *NONE / *SAME / string_expression15 ,WHEN6 = *NONE / string_expression6, THEN6 = *NONE / *SAME / string_expression16 ,WHEN7 = *NONE / string_expression7, THEN7 = *NONE / *SAME / string_expression17 ,WHEN8 = *NONE / string_expression8, THEN8 = *NONE / *SAME / string_expression18 ,WHEN9 = *NONE / string_expression9, THEN9 = *NONE / *SAME / string_expression19 ,WHEN10 = *NONE / string_expression10, THEN10 = *NONE / *SAME / string_expression20 ,ELSE = *NONE / *SAME / string_expression21 |