UPPER: Returning a String With All Letters Uppercase

How to:

The UPPER function takes a source string and returns a string of the same data type with all letters translated to uppercase.

Top of page
x
Syntax: How to Return a String With All Letters Uppercase
UPPER(source_string)

where:

source_string

Alphanumeric

Is the string to convert to uppercase.

The returned string is the same data type and length as the source string.
Example: Converting Letters to Uppercase

LAST_NAME_MIXED has the last name in mixed case. UPPER converts LAST_NAME_MIXED to uppercase.

UPPER(LAST_NAME_MIXED)

For Banning , the result is BANNING.

iWay Software