UCASE() is a synonym for UPPER(). mysql> SELECT UPPER('abc');+--------------+| UPPER('abc') |+--------------+| ABC |+--------------+1 row in set (0.00 sec)mysql>