Skip to main content
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

ParameterDescriptionSupported 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