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
- To change how a field displays without modifying its contents, see Text formatting functions.
Example 1
Upper ( "Ca" ) returns CA.
Upper ( "12n34p" ) returns 12N34P.