Sign in Get started

SQLite 3 reference · String Functions

SQLite UPPER() Function

Return a copy of a string with ASCII letters converted to uppercase. Letters such as é are left unchanged.

SQLite 3

Create a free account to save this page, take notes and track your progress. Sign in

Syntax

upper(X)

Parameters

ParameterDescription
X The string (other values are converted to text).

Return value

Text, or NULL if X is NULL.

Examples

Uppercase a columnTry it yourself
SELECT name, upper(name) AS shouted
FROM customers
LIMIT 3;

Output

name | shouted
Ada Lovelace | ADA LOVELACE
Alan Turing | ALAN TURING
Grace Hopper | GRACE HOPPER
Only ASCII letters changeTry it yourself
SELECT upper('café') AS result;

Output

result
CAFé

Without the ICU extension SQLite only changes the 26 ASCII letters. Do Unicode case conversion in your application code, or load ICU, when you need it.

In other languages

  • LOWER() · Return a copy of a string with ASCII letters converted to lowercase. Handy for case-insensitive comparisons.
  • LIKE · Match a string against a pattern with % (any run of characters) and _ (one character). Case-insensitive for ASCII.
  • SQL String Functions · tutorial

Was this page helpful?