upper

Type

Text Function

Purpose

The upper function converts each letter in a text value to uppercase.

Syntax

upper( TEXT VALUE)

Returns

The specified text value with all the letters in uppercase.

The upper function only affects the alphabetical letters a-z. Numeric values are not converted to their Shift key equivalents.

Examples

upper( "DataEase" )

Returns: DATAEASE

upper( "Cancun" )

Returns: CANCUN

upper( LAST NAME)

Returns the value in the LAST NAME field in uppercase type for every record processed. If a record contains the value Birnbaum in the LAST NAME field, the function returns BIRNBAUM.