> ## Documentation Index
> Fetch the complete documentation index at: https://www.integrate.io/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# 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('JohnSmith@GOTMAIL.COM')` returns '[johnsmith@gotmail.com](mailto:johnsmith@gotmail.com)'

## Return value datatype

String

## Impact of null value

If input is null, returns null.