upper(str)

Returns a copy of string str with all cased characters converted to uppercase.

Example

This example returns the first five entries in the City column in uppercase.

SELECT upper(City) as upperCity FROM "Superstore"
GROUP BY City
LIMIT 5;
upperCity
ABERDEEN
ABILENE
AKRON
ALBUQUERQUE
ALEXANDRIA