The UPPER Function in SQL

The UPPER function is contrary to the LOWER function and returns all characters in uppercase letters as shown in the following statement where each employee’s first name is displayed in uppercase.

Microsoft Access uses UCASE() function.

    Syntax :
UPPER (character)

    SQL Statement :

SELECT    UPPER(first_name)

FROM       employees;

    Output :