UCASE()

Function Description

UCASE() is used to convert the given string to uppercase, as a synonym for UPPER().

Function Syntax

> UCASE(str)

Parameter definition

Parameters	Description
str	Required parameters, alphabetical characters.

Example

mysql> select ucase('hello');
+-------------------+
| ucase(hello) |
+-------------------+
| HELLO |
+-------------------+
1 row in set (0.03 sec)

mysql> select ucase('a'),ucase('b'),ucase('c');
+------------------------------------+
| ucase(a) | ucase(b) | ucase(c) |
+------------------------------------+
| A | B | C |
+------------------------------------+
1 row in set (0.03 sec)