SQLite Upper

SQLite upper function returns a copy of a string with all letter characters converted to uppercase. Note that the SQLite built-in implementation of the upper function only works with ASCII characters, which are characters that have a value less than 128.

If you want to use the upper function for the Unicode characters, you use the ICU based function.

Syntax

upper(string)Code language: SQL (Structured Query Language) (sql)

Arguments

string

The upper function accepts one string argument.

Return Type

TEXT

Examples

The following statement uses the upper function to returns the uppercase form of a string.

SELECT upper('sqlite upper');Code language: SQL (Structured Query Language) (sql)

upper('sqlite upper')
---------------------
SQLITE UPPER

The following query returns the titles of all albums in the uppercase form.

SELECT Title,
       upper(Title) 
FROM albums
ORDER BY Title;Code language: SQL (Structured Query Language) (sql)

The following picture shows the partial output: