Category: Text

Syntax: Upper ( text )


textA string or text expression.

Data type returned: text


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




Upper ("This is a test")


Upper (AccessCode)

Returns 1ABC-2XYZ when AccessCode contains "1abc-2XYz".

: FileMaker Specifications

FileMaker 8 Product Line

Specifications and Storage Limits

Field Types and Import/Export Formats

: Calculation Functions

Working with Calculations Primer

Calculation Signatures

Calculation Functions

: Custom Functions

Custom Functions Primer

Useful Custom Functions

: Script Steps

Scripting Primer

Script Step Reference

: Quick Reference

FileMaker Error Codes

FileMaker Keyboard Shortcuts

FileMaker Network Ports

FileMaker Server Command Line Reference

FileMaker XML Reference

: Other Resources

Where to Go for More Information

FileMaker 8 Functions and Scripts Desk Reference
FileMaker 8 Functions and Scripts Desk Reference
ISBN: 0789735113
EAN: 2147483647
Year: 2004
Pages: 352

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net