Upper()

 <  Day Day Up  >  

Upper()

Category: Text

Syntax: Upper ( text )

Parameters: text ”a string or text expression.

Description: Returns a completely uppercase version of the specified text string.

Examples:

 

 Upper ("This is a test") 

Returns THIS IS A TEST .

 

 Upper (AccessCode) 

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

Comments:

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

 <  Day Day Up  >  


QUE CORPORATION - Using Filemaker pro X
QUE CORPORATION - Using Filemaker pro X
ISBN: N/A
EAN: N/A
Year: 2003
Pages: 494

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