Upper (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". The Upper function can be used to display information in all upper case for attribute forms.

Syntax

Upper(Argument)

Where:

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

For information on the syntax used in your specific database, see MicroStrategy and Database Support for Functions and see the section that corresponds to your database.

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.