Converts a string value to uppercase characters.

Syntax

UCASE(expression)

UPPER(expression)

Arguments

  • expression: a character expression of one of these types, or an expression that resolves to one of these types:
    • CHAR
    • VARCHAR
    • LONG VARCHAR

Returns

  • The same data_types as expression.

Additional Information

  • UCASE and UPPER are both supported, perform the same function, and can be used interchangeably.

Examples

SELECT firstName, UPPER(firstName) AS firstNameUpper FROM MYSQL.inventory.cust;

VALUES UCASE('John Smith');
-- Returns JOHN SMITH