UPCASE: Converting Text to Uppercase (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 Calling a Function.

There is also an UPCASE function available for the reporting language. For information on this function, see UPCASE: Converting Text to Uppercase.


Top of page

x
Syntax: How to Convert Text to Uppercase
UPCASE(string)

where:

string

Alphanumeric

Is the character string to be converted to uppercase.


WebFOCUS