Lower (Lower Case)

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

Lower may be used to help standardize the display of information and make the information more readable.

Syntax

Lower(Argument)

Where:

Argument is a metric, column, or string value 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

The Lower function can be used to display information in all lower 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 lower case. The definition of such an attribute form is shown below:

Lower([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.