UPPER()

Documentation

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

UPPER( string-expression )

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

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);