|
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 field.
UPCASE(length, source_string, output)
where:
Integer
Is the number of characters in source_string and output.
Alphanumeric
Is the string to convert.
Alphanumeric of type AnV or An
| WebFOCUS | |
|
Feedback |