Converts a string value to uppercase characters.
- expression: a character expression of one of these types, or an expression that resolves to one of these types:
- LONG VARCHAR
- The same data_types as expression.
- UCASE and UPPER are both supported, perform the same function, and can be used interchangeably.
SELECT firstName, UPPER(firstName) AS firstNameUpper FROM MYSQL.inventory.cust; VALUES UCASE('John Smith'); -- Returns JOHN SMITH