The UPPER function

Use the UPPER function to replace every lowercase letter in a character string with an uppercase letter. The UPPER function accepts an argument of a character data type and returns a value of the same data type as the argument you specify.

The following query uses the UPPER function to convert any lowercase letters in a character string to uppercase letters.

Figure 1. Query

SELECT call_code, UPPER(code_descr) FROM call_type

Figure 2. Query result

call_code    (expression)

B            BILLING ERROR
D            DAMAGED GOODS
I            INCORRECT MERCHANDISE SENT
L            LATE SHIPMENT
O            OTHER