LOWER

Converts all the characters in the string to lowercase.

Syntax

= LOWER(value)

Parameters

value

A string which is to be converted to lowercase.  The value can be specified as an integer (e.g., 37), a decimal value (e.g., 37.48), as a string (“Word”), or as the value of a variable (e.g, FirstName).

Return Type

String

In the case of an error, the function displays an error message: “LOWER(value): Error message”

The function can be used in combination with other functions.

Examples

Example

Returns

= LOWER(“TeSt”)

“test”

= LOWER(“Iron Speed Designer”)

“iron speed designer”

= LOWER(Product)

The lower case converted version of the value of Product.

= LOWER(FirstName)

The lower case converted version of the value of FirstName.

= LOWER(RIGHT(“Iron Speed Designer”, 8))

A lower case version of the extracted string.

= LOWER(CONCATENATE(“Iron”, “Speed”, Designer”))

A lowercase version of the concatenated string.