The LCase function
converts a string to lowercase.
Returns: A string.
Parameters
- StringExpression
- Specifies the string to be converted to lowercase.
Example
The following example uses the LCase function to return the sales amount for product departments with a name that contains "teen", irrespective of case.
Query
SELECT {[Price Analysis].[Measures].[Sales Amount]}
ON AXIS(0),
{Filter([Price Analysis].[Product].[All Products].Children,
InStr(LCase([Price Analysis].[Product].CurrentMember.Name), "teen") > 0)}
ON AXIS(1)
FROM [Price Analysis]
Result
| Product | Sales amount |
|---|---|
| PETITE BOY TEENS | 11893.53 |
| PETITE GIRL TEENS | 19611.68 |
| TEEN BOYS | 48320.57 |
| TEEN BOYS JEANS | 46876.68 |
| TEEN GIRLS | 35005.8 |
| TEEN GIRLS JEANS | 52952.56 |
Related functions
You can convert a string to uppercase with the UCase function.