Syntax: Lower ( text )
textAny expression that resolves to a text string.
Data type returned: Text
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))
Lower ("This is a test")
Returns this is a test.
Returns mary smith when the Name field contains "MARY Smith".