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.

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