Upper()

Category: Text

Syntax: Upper ( text )

Parameters:

textA string or text expression.

Data type returned: text

Description:

Returns a completely uppercase version of the specified text string.

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

The Upper() function is often used to reformat user-entered data to ensure consistent data entry. Sometimes when exporting data that is to be used by external applications, you need to format the data entirely as uppercase characters to be consistent with data in the other system.

The following formula checks whether a given text string is already written in all uppercase characters:

 Exact (text; Upper(text))

Examples:

Function	Results
Upper ("This is a test")	Returns THIS IS A TEST.
Upper (AccessCode)	Returns 1ABC-2XYZ when AccessCode contains "1abc-2XYz".