LOWER
Converts uppercase string characters to lowercase.
Syntax
LOWER( string )
The following table describes the argument for this command:
Argument | Required/ Optional | Description |
|---|
string | Required | Any string value. The argument passes the string values that you want to return as lowercase. You can enter any valid transformation expression that evaluates to a string. |
Return Value
Lowercase character string. If the data contains multibyte characters, the return value depends on the code page and data movement mode of the Integration Service.
NULL if a value in the selected port is NULL.
Example
The following expression returns all first names to lowercase:
LOWER( FIRST_NAME )
FIRST_NAME | RETURN VALUE |
|---|
antonia | antonia |
NULL | NULL |
THOMAS | thomas |
PierRe | pierre |
BERNICE | bernice |