MySQL UCASE Function

MySQL UCASE is a synonym of UPPER Function. This String method 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 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, NULL, and numbers in string format. Remember, this String method returns NULL for NULL argument value. Please refer to the UPPER Function article.

SELECT UCASE('');

SELECT UCASE(NULL);

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