UPPER

Converts all characters in expr to uppercase.

Syntax

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

select
    upper('LOREM Ipsum Dolor Sit Amet, ConseteTur') as result;

+----------------------------------------+
|                RESULT                  |
+----------------------------------------+
| LOREM IPSUM DOLOR SIT AMET, CONSETETUR |
+----------------------------------------+