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: