Upper
Purpose 
Returns all letters in text as uppercase.
Format 
Upper(text)
Parameters 
text - any text expression or text field
Data type returned 
text
Originated in 
FileMaker Pro 6.0 or earlier
Description 
Use the Upper function to ensure consistent data entry of such things as state abbreviations or postal codes.
Note  To change how a field displays without modifying its contents, see Text formatting functions.
Examples 
Upper(“Ca”) returns CA.
Upper(“12n34p”) returns 12N34P.
Related topics 
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas
Was this topic helpful? Send feedback.