SQLite lower() function

You organize your data. Now organize your savings.

Set savings goals, track your progress, and stay on course.

Get Savigo for iPhone ›

The SQLite lower() function returns a new string with all ASCII characters converted to lowercase. For handling Unicode characters, you can utilize the ICU extension of this function.

Syntax #

lower(string)Copy

Arguments #

The lower() function accepts one argument that has the text data type.

string

The input string will be converted to lowercase.

Return Type #

TEXT

Examples #

The following statement uses the lower() function to return the lowercase of a string:

SELECT lower('SQLite LOWER');Copy

Output:

lower('SQLite LOWER')
---------------------
sqlite lowerCopy

The following query selects the first name, last name, and lowercase email of the employees in the employees table.

SELECT
  lastname,
  firstname,
  lower(email)
FROM
  employees;Copy

See Also #

upper() function