UPPER(str)
UCASE(str)
Returns the string str
with all characters changed to uppercase according to the current character set mapping. The default is latin1 (cp1252 West European).
UCASE
is a synonym.
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.
This page is licensed: GPLv2, originally from fill_help_tables.sql