LOWER (x)

Description:

This function converts a given string into "LOWER" case and returns the computed string value as the result.

Syntax: LOWER (Text)

• Text : is the text which you want to convert into Lower Case through the use of this function.

Remarks

• The text parameter argument is compulsory.
• If you specify a number instead of a text value as this parameter, the function would return an error which is #VALUE.
• However if you specify a number within double quotes, then the number is taken to be a text value and accordingly its characters are converted to small letters and the converted text is returned.

Example

You can use the LOWER function to convert the text that is given to the function as a parameter. This function can be used in any database where you have stored characters as text values and where you want to convert these text values into Lower Case and return that value as the result of the function. This function displays the given text value as a Lower Case value. The input given to the function can be all Upper Case, or mixed Upper and Lower Case, it doesn't matter, whatever the input value, the function will uniformly convert the case of the text value to "Lower".

=LOWER ("A")	-Lower Case of the specified string ("a")
=LOWER ("PeNNSyLVANIa")	-Lower Case of the specified string ("pennsylvania")
=LOWER ("lower")	-Lower Case of the specified string ("lower")

 

Note: A number supplied within double quotes will be taken as a string parameter.

 

Let us take the example of a database in PowerOLAP where we have certain text values for name, last name, city, country etc., and we need to access and / or manipulate these text values and arrive at results with different permutations and combinations. We shall use this example in this case to ascertain the LOWER value based on the information provided by the "City" member that has the value for names of the cities which values are supplied to the function. In this case, we have written a formula in the appropriate cube in PowerOLAP, pulling in the value from the "City" member and then writing that value to this formula in order to calculate the result of the "LOWER" function.



The formula above writes values into the "StringDataFunctions" cube to the "String Data Manipulations" dimension into the member named "LOWER" by calculating the lower case value for the parameter specified deriving the base from the "City" member in the "String Values" dimension which forms the parameter supplied to this function and its for this parameter that the corresponding "Lower Case" value is returned.