The LOWER function sets all of the characters in a text string to lower case. This function is the opposite of the UPPER function.
Category
String
Syntax
LOWER(text_string)
Parameter and Description
| Parameter | Description |
|---|---|
| text_string | This parameter specifies a character string of one (1) or more words. This character string can be a field from a source datastore, a constant, a variable or the result of another Function. |
Example
Translate the text string in source field SRC_STRING, which contains the value A Brown Dog Jumped OverThe Fence into lower case and map it to target field TGT_STRING.
TGT_STRING = LOWER(SRC_STRING)
The value mapped into target field TGT_STRING will contain 'a brown dog jumped over the fence'.