The UPPER function sets all of the characters in a text string to upper case. This function is the opposite of the LOWER function.
Category
String
Syntax
UPPER(text_string)
Parameter and Description
| Parameter | Description |
|---|---|
| text_string | This parameter specifies a character string of one (1) or more words. This character string can be a field from a source datastore, a constant, a variable or the result of another Function. |
Example
Translate the text string in source field SRC_STRING, which contains the value A Brown Dog Jumped Over The Fence into lower case and map it to target field TGT_STRING.
TGT_STRING = UPPER (SRC_STRING)
The value mapped into target field TGT_STRING will contain 'A BROWN DOG JUMPED OVER THE FENCE'.