MDX Functions that Return a String

The following functions return a string.

Table 4-33 MDX String Functions

Function	Result
FormatDate	Formats date strings.
Concat	Concatenates input strings.
Left	Returns a specified number of characters from the left side of the string.
Right	Returns a specified number of characters from the right side of the string.
LTrim	Trims whitespace on the left of the string.
RTrim	Trims whitespace on the right of the string.
Lower	Converts upper-case string to lower case.
Upper	Converts lower-case string to upper case.
Substring	Returns the substring between a starting and ending position.
NumToStr	Converts a double-precision floating-point value into a decimal string.