UPPER()

Function Description

UPPER() is used to convert the given string to uppercase.

Function Syntax

> UPPER(str)

Parameter definition

Parameters	Description
str	Required parameters, alphabetical characters.

Example

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

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