LOWER
Converts uppercase string characters to lowercase.
Syntax
LOWER( string )
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 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 of the Secure Agent that runs the task.
NULL if a value in the selected column 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 |