LOWER

Converts the input string to lowercase characters. Note that Firebolt uses the POSIX locale, therefore lower only converts the ASCII characters “A” through “Z” to lowercase. Non-ASCII characters remain unchanged.

Syntax

LOWER(<expression>)

Parameters

Parameter	Description	Supported input types
`<expression>`	The string to be converted to lowercase characters.	`TEXT`

Return Type

TEXT

Examples

The following example converts a game player’s username from uppercase to lowercase characters:

SELECT LOWER('ESIMPSON') AS username;

username text
esimpson

Rows: 1Execution time: 7.05ms

Because Firebolt uses the POSIX locale, non-ASCII characters are not lowercased:

SELECT LOWER('MÜNCHEN');

lower text
mÜnchen

Rows: 1Execution time: 4.79ms

LPAD

⌘I

Overview

Performance and Observability

Security

Self-Managed

Managed service

Guides

SQL reference

Release notes

API reference

Legal

Syntax

Parameters

Return Type

Examples

​Syntax

​Parameters

​Return Type

​Examples

Syntax

Parameters

Return Type

Examples