Lower()

Lower()

Category: Text

Syntax: Lower ( text )

Parameters: text ”any expression that resolves to a text string.

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

Examples:

 Lower ("This is a test") 

Returns this is a test .

 Lower (Name) 

Returns mary smith when the Name field contains "MARY Smith" .

Comments:

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))