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.

Syntax: How to Return a String With All Letters Uppercase

UPPER(string)

where:

string

Alphanumeric

Is the string to convert to uppercase.

The returned string is the same data type and length as the source string.

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.

	WebFOCUS