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/