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