Upper Case

The Upper function returns a string in which all alphabetic characters in an input string are displayed as upper case. For example, using the Upper function on the string "MicroStrategy" would return the string "MICROSTRATEGY".

Syntax

Upper(Argument)

Where:

Argument is a metric, column, or string representing the text string(s).

Example

The Upper function can be used to display information in all upper case for attribute forms. For example, an LU_CUSTOMER table includes an ADDRESS column. You can create an attribute form to display all characters for a customer's address in upper case. The definition of such an attribute form is shown below:

Upper([ADDRESS])

An attribute form using a definition such as the one listed above would take input addresses such as 10 Main Street, 350 West Elm Avenue, and 4400 Spring Road and display them as 10 MAIN STREET, 350 WEST ELM AVENUE, and 4400 SPRING ROAD, respectively.