Skip to main content

LOWER

Returns an input string in lowercase.

See also:
[SELECT] [UPPER] [ Data Types ]

Syntax​

SELECT LOWER(character_expression) FROM <multipartIdentifier>;

The lower() function works for ASCII characters only.

Arguments​

character_expression
An ASCII string.

Return Value(s)​

Returns a string value.

Examples​

Return a string in lowercase​

SELECT name, LOWER(location) FROM google.storage.buckets WHERE project = 'stackql-demo';

For more information, see https://www.sqlite.org/lang_corefunc.html#lower