Function group: string function
UPPER() converts the lowercase characters in a string to uppercase characters.
UPPER ( expression )
expression
Alphanumeric expression or national expression.
Result
When expression returns the NULL value, the result is the NULL value.
Otherwise:
If expression is an alphanumeric expression, the result is a copy of the string which results from the evaluation of expression, lowercase letters of the SESAM/SQL character repertoire (see "SESAM/SQL character repertoire") being replaced by equivalent uppercase letters (a-z without umlauts and ß).
If expression is a national expression, lowercase letters are replaced by equivalent uppercase letters in accordance with the Unicode rules (as with the XHCS function
toupper).
Data type: like expression
Examples
SELECT UPPER(city) FROM customers WHERE cust_num=100
Returns the string 'MUNICH'.
UPPER('ä')
Returns the value 'ä'.
UPPER(NX'00E4')
Returns the value NX'00C4' (which corresponds to 'Ä') because the Unicode rules are used.