1. Calculation functions
  2. All Functions
  3. Miscellaneous Functions
  4. LOWER

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

Back to Top

Example

LOWER(LineItemToBeConverted)

The content of line item is converted to lower case.

LOWER("LineItemToBeConverted")

Returns lineitemtobeconverted.

Back to Top

Similar functions