MySQL UCASE Function

MySQL UCASE is a synonym of the UPPER Function. This String method is to convert the given string into uppercase. The syntax of the UCASE Function is as shown below:

SELECT UCASE(String_Expression) FROM [Source]

MySQL UCASE Function Example

The UCASE function converts the user-specified string expression into an uppercase. The following MySQL query shows you the same. Also, read about the MySQL UPPER from the available MySQL String functions.

SELECT UCASE('Mysql Tutorial');

SELECT UCASE('Tutorial gateway');

SELECT UCASE('hi everyone!');

In this example, we are going to use the UCASE function on an empty, NULL, and numbers in string format. Remember, this String method returns NULL for NULL argument value.

TIP: Please refer to the MySQL LOWER and MySQL TRIM functions.

SELECT UCASE('');

SELECT UCASE(NULL);

SELECT UCASE('123');