LOWER

​

Syntax

​

Scalar

lower(value)

​

Arguments

​

Returns

• Type: STRING
• Possible values: A string after Unicode case conversion.
• NULL behavior: Returns NULL for NULL input.

​

Properties

​

Usage notes

• Unicode case conversion can change the number of characters.

​

Examples

​

Typical behavior

SELECT lower('aBc') AS "value", lower(CAST(NULL AS STRING)) AS null_value;

​

Leave digits and punctuation unchanged

SELECT lower('Order-ABC123') AS normalized;