Lower()

Category: Text

Syntax: Lower ( text )

Parameters:

textAny expression that resolves to a text string.

Data type returned: Text

Description:

Returns an all-lowercase version of the specified text string.

The Lower() function is one of three functions FileMaker has for changing the case of a text string. The other two are Upper() and Proper().

The following formula can be used to test whether a given text string is already written with all lowercase characters:

 Exact (text; Lower(text))

Examples:

Function	Results
Lower ("This is a test")	Returns this is a test.
Lower (Name)	Returns mary smith when the Name field contains "MARY Smith".