Function: Lower

Description

Converts all uppercase letters in a string to lowercase letters.

Syntax

Lower(string)

Arguments

string can be a constant, a character field, an expression that results in a string or a function that returns a string.

Return value

This function returns a character string.

Calculated field example

If the Billing field contained the value Monthly, the following calculated field expression would return monthly: Lower(Billing)

Filter/Find example

All filter expressions are case insensitive, so Lower has no practical application. For find expressions, use the Match Case setting to determine case sensitivity.