UPPER function - Amazon Redshift
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

UPPER function

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





The input parameter is a VARCHAR string or any other data type, such as CHAR, that can be implicitly converted to VARCHAR.

Return type

The UPPER function returns a character string that is the same data type as the input string. For example, the function will return a VARCHAR string if the input is a VARCHAR string.


The following example uses data from the CATEGORY table in the TICKIT sample database. For more information, see Sample database.

To convert the CATNAME field to uppercase, use the following.

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 | +-----------+-----------+