Available Operating Systems: All Available Languages: Maintain |
How to: |
The UPCASE function converts a character string to uppercase. It is useful for sorting on a field that contains both mixed case and uppercase values. Sorting on a mixed case field produces incorrect results because the sorting sequence in EBCDIC always places lowercase letters before uppercase letters, while the ASCII sorting sequence always places uppercase letters before lowercase. To obtain correct results, define a new field with all of the values in uppercase, and sort on that.
To use this function, you must import the function library MNTUWS. For information on importing this library see How to Access the Maintain MNTUWS Function Library.
There is also an UPCASE function available for the reporting language. For information on this function, see UPCASE: Converting Text to Uppercase.
UPCASE(string)
where:
string
Alphanumeric
Is the character string to be converted to uppercase.