SQLite lower() Function

The SQLite lower() function converts the given string to lowercase and returns it.

Syntax

This is the syntax of the SQLite lower() function:

lower(str)

Parameters

str

Required. A string that needs to be converted to lowercase.

Return value

The SQLite lower() function returns the lowercase form of the specified string.

If the parameter is NULL, the function will return NULL.

Examples

This example shows how to convert a string to lowercase using the lower() function.

SELECT lower('Hello World');

lower('Hello World')
--------------------
hello world