7.1
2013-09-23

UPPER

Syntax

UPPER(Text)

Description

Returns all letters in the given text as uppercase. Use the UPPER function to ensure consistent data entry of such things as state abbreviations or postal codes.

Example

UPPER ("Personalized Printing") => PERSONALIZED PRINTING

Parameter description

Text

Any text expression or data field containing a text.

You can use this function to print the selected database field in capital letters.

If you are creating a mailing for which you need to print the names in capitals, although the names in the database are in lowercase, perform the conversion with UPPER.