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 version 

6.0 or earlier

Description 

Use the Upper function to ensure consistent data entry of such things as state abbreviations or postal codes.

Notes 

Example 1 

Upper ( "Ca" ) returns CA.

Upper ( "12n34p" ) returns 12N34P.