MySQL UCASE Function

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

SELECT UCASE(String_Expression) FROM [Source]

MySQL UCASE Function Example

The MySQL Uppercase Function converts the user-specified string expression into an uppercase. The following MySQL query shows you the same

SELECT UCASE('Mysql Tutorial');

SELECT UCASE('Tutorial gateway');

SELECT UCASE('hi everyone!');
MySQL UCASE Function 1

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

SELECT UCASE('');

SELECT UCASE(NULL);

SELECT UCASE('123');
MySQL UCASE Function 2

Please refer to the UPPER Function article.