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)
See Also
Was this tutorial helpful ?