UPPER()

Function Description

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

Function syntax

> UPPER(str)

Parameter interpretation

Parameters	Description
str	Required parameters, alphabetic characters.

Examples

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)