Menu
Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

UPPER Function

Converts a string to uppercase. UPPER supports UTF-8 multibyte characters, up to a maximum of four bytes per character.

Syntax

Copy
UPPER(string)

Arguments

string

The input parameter is a CHAR or VARCHAR string.

Return Type

The UPPER function returns a character string that is the same data type as the input string (CHAR or VARCHAR).

Examples

The following example converts the CATNAME field to uppercase:

Copy
select catname, upper(catname) from category order by 1,2; catname | upper ----------+----------- Classical | CLASSICAL Jazz | JAZZ MLB | MLB MLS | MLS Musicals | MUSICALS NBA | NBA NFL | NFL NHL | NHL Opera | OPERA Plays | PLAYS Pop | POP (11 rows)