Jump to: navigation, search

Mysql UCASE

From w3cyberlearnings

Contents

MySQL UCASE Function

This function returns a given string to all uppercase. It is equal to UPPER() function.

Syntax UCASE

  • Str: a given string
UCASE(Str);

Example 1

mysql> SELECT UCASE('Hello');
+----------------+
| UCASE('Hello') |
+----------------+
| HELLO          |
+----------------+
1 row in set (0.00 sec)

Example 2

mysql> SELECT UCASE('goes');
+---------------+
| UCASE('goes') |
+---------------+
| GOES          |
+---------------+
1 row in set (0.00 sec)

Related Links


Navigation
Web
SQL
MISC
References