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

​
Example

The following example converts a game player’s username from uppercase to lowercase characters: 
SELECT
	LOWER('ESIMPSON') as username
Returns: esimpson Because Firebolt uses the POSIX locale, non-ASCII characters are not lowercased: 
SELECT LOWER('MÜNCHEN')
Returns: mÜnchen
⌘I