Overview
The SQLite LOWER() Function converts a string into lowercase letters. We can use this function to convert column text values to lowercase.
SQLite LOWER() Function
Syntax
The general syntax of the LOWER() function is as follows:
LOWER(argument)
LOWER(column_name)
Example
Let’s understand the function usage with the help of an example.
SELECT LOWER(ename), LOWER(jobtitle)
FROM emp ;
The columns ‘ename’ and ‘jobtitle’ will be converted into lowercase letters in the query results.
—
SQLite Tutorials
SQLite tutorials on this website:
https://www.testingdocs.com/sqlite-database-tutorials/
For more information on SQLite, visit the official website: