Converts text source x to all lowercase.
Syntax
LOWER(x)
where:
- x: Text to be converted
LOWER(x,y)
where:
- x: Text to be converted
- y: Locale (optional)
Format
| Input Format | Output Format |
|---|---|
|
x: Text y: Locale |
Text |
Arguments
The function uses the following arguments:
- x: Text: Text-formatted line item, text constant, or general expression
- y: Text (optional): Text-formatted line item, text constant, or general expression
Constraints
The function has no constraints.
Excel equivalent
Example
LOWER(LineItemToBeConverted)
The content of line item is converted to lower case.
LOWER("LineItemToBeConverted")
Returns lineitemtobeconverted.