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".








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

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