This documentation is related to an older version of Firebolt. For the most current documentation, see Firebolt documentation.
LOWER
Converts the input string to lowercase characters.
Syntax
LOWER(<expression>)
Parameters
| Parameter | Description | Supported 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