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".

Syntax

Lower(Argument)

Where:

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

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.