UPPER

 

Syntax

UPPER(string_value)

Description

Converts all characters in <string_value> to uppercase

Example

UPPER ("John Abrahams") => JOHN ABRAHAMS

 

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.