Convert a string to uppercase. This function returns the string with all characters converted to uppercase.
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.
UPPER() is ineffective when applied to binary strings (, , ). The description of () shows how to perform lettercase conversion of binary strings.
This page is licensed: GPLv2, originally from
SELECT UPPER(surname), givenname FROM users ORDER BY surname;
+----------------+------------+
| UPPER(surname) | givenname |
+----------------+------------+
| ABEL | Jacinto |
| CASTRO | Robert |
| COSTA | Phestos |
| MOSCHELLA | Hippolytos |
+----------------+------------+