ETL: LOWER

Convert all characters in a string expression to lowercase. Use LOWER for case-insensitive matching and text normalization in ETL data pipelines.

Description

Converts the characters in a string_expression to lower case.

Syntax

LOWER(string_expression)

Examples

LOWER('[e-mail]') returns ‘[e-mail]’

Return value datatype

String

Impact of null value

If input is null, returns null.