SQLite Lower

The SQLite lower() function returns a copy of a string with all ASCII characters converted to lowercase. For the Unicode characters, you should use the ICU extension of this function.

Syntax

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

Arguments

The lower() function accepts one argument which has TEXT data type.

string

The input string that will be converted to lowercase.

Return Type

TEXT

Examples

The following statement returns the lowercase of a string.

SELECT lower('SQLite LOWER');Code language: SQL (Structured Query Language) (sql)
lower('SQLite LOWER')
---------------------
sqlite lower

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;Code language: SQL (Structured Query Language) (sql)
SQLite LOWER example

See Also

upper() function

Was this tutorial helpful ?