UPPER Function in MS SQL Server and it's equivalent in MySQL

MSSQL

The UPPER function in MSSQL is used to convert a string into upper case. It's similar to LOWER function which converts the string to lower case.

Syntax

UPPER(string)

Examples

select UPPER('This is demo');

------------------------
THIS IS DEMO

select UPPER(name) from emp;

-------------------------
SMITH
JOHN
SCOTT
THOMAS

MySQL

In MySQL the same functionality can be obtained by using UPPER or UCASE function.  The UCASE function in MySQL is a synonym for UPPER function.

Syntax

UPPER(string)
UCASE(string)

Example

mysql> select UPPER('This is Demo');
+-----------------------+
| UPPER('This is Demo') |
+-----------------------+
| THIS IS DEMO |
+-----------------------+
1 row in set (0.00 sec)

mysql> select UCASE('This is Demo');
+-----------------------+
| UCASE('This is Demo') |
+-----------------------+
| THIS IS DEMO |
+-----------------------+
1 row in set (0.00 sec)

Back to Converting Functions from MSSQL to MySQL