MySQL UCASE() Function

In MySQL, the UCASE() function converts the specified string to upper and returns it.

The UCASE() function is the same as UPPER() function.

If you want to convert a string to lowercase, use the LCASE() or LOWER().

UCASE() Syntax

Here is the syntax of MySQL UCASE() function:

UCASE(str)

Parameters

str

Required. The string to be processed.

Return value

The UCASE(str) function returns the uppercase form of the specified string.

The function will NULL return when the str parameter is NULL.

UCASE() Examples

SELECT UCASE('Hello'), UCASE(NULL);

+----------------+--------------------------+
| UCASE('Hello') | UCASE(NULL)              |
+----------------+--------------------------+
| hello          | NULL                     |
+----------------+--------------------------+