UPPER
Converts all characters in expr to uppercase.
Syntax
sql
UPPER(expr)Arguments
expr: The STRING value to be processed.
Return Values
The return value has the same data type as expr.
Usage Notes
The determination of uppercase and lowercase characters is based on the binary mapping defined for the underlying character set.
Example
sql
select
upper('LOREM Ipsum Dolor Sit Amet, ConseteTur') as result;+----------------------------------------+
| RESULT |
+----------------------------------------+
| LOREM IPSUM DOLOR SIT AMET, CONSETETUR |
+----------------------------------------+