UPPER()

UPPER() — Returns a string converted to all uppercase characters.

Synopsis

UPPER( string-expression )

Description

The UPPER() function returns a copy of the input string converted to all uppercase characters.

Example

The following example uses the UPPER function to return results alphabetically regardless of case.

SELECT UPPER(product_name), product_id  FROM product_list
    ORDER BY UPPER(product_name);