Syntax
------

UPPER(str)

Description
-----------

Returns the string str with all characters changed to uppercase according to
the current character set mapping. The default is latin1 (cp1252 West
European).

SELECT UPPER(surname), givenname FROM users ORDER BY surname;
+----------------+------------+
| UPPER(surname) | givenname  |
+----------------+------------+
| ABEL           | Jacinto    |
| CASTRO         | Robert     |
| COSTA          | Phestos    |
| MOSCHELLA      | Hippolytos |
+----------------+------------+

UPPER() is ineffective when applied to binary strings (BINARY, VARBINARY,
BLOB). The description of LOWER() shows how to perform lettercase conversion
of binary strings.

URL: https://mariadb.com/kb/en/upper/