LOWER

Converts a string to all lowercase letters.

This function corresponds to the lower(X) function in SQLite. It takes a string value and returns a new string with all uppercase ASCII characters converted to their lowercase equivalents. The behavior for non-ASCII characters is dependent on the SQLite version and build options (e.g., if ICU is enabled).

If the input is not a string, it is first coerced into one. A NULL input results in a NULL output.

Example

// SELECT lower(productName) FROM Products
val lowerCaseName = select(LOWER(Products.productName)).from(Products)

Return

A KQLiteColumn of type String containing the lowercase version of the string.

Author

MOHAMMAD AZIM ANSARI

Parameters

column

The column containing the string to be converted to lowercase.

See also