<< Click to Display Table of Contents >> Navigation:  Available Functions > Upper()

Syntax

Upper( <FieldName> )

 

Purpose

To make fields appear as if all their data was entered in upper case.

 

Parameters

The name of a field, or a character expression.

 

Returns

A Character value.

 

Usage

This function is useful when you want to compare the contents of character fields in selection conditions without having to worry about proper capitalization.

 

Example

You want to know all the donors with a last name of "Smith". "Upper()" will allow you to create a selection condition that could look at all the last names as if they were all upper case. This is very convenient since you need to account for the data entry person having accidentally entered "smith" instead of "Smith". Using the "Upper()" function would enable you to set up a condition like this:

 

Upper( .Last_Name. ) = "SMITH"

 

Notice how we used all upper case letters for the specific value "SMITH" in the condition.