Reference > Functions reference > Text functions > Upper
 

Upper

Returns all letters in specified 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.

Notes 

To change how a field displays without modifying its contents, see Text formatting functions.

Example 1 

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