Syntax
TRANSLATE
TRANSLATE
These statements convert all lower case letters in the field
You can use TRANSLATE to substitute the characters in a string like replace. But the main difference between Translate and Replace is that Replace statement replaces only one occurrence of particular character while Translate replaces all the occurrences of the character.
When using substitution rules, use the following syntax:
Syntax
TRANSLATE
No comments:
Post a Comment