MicroStrategy ONE
Char (Convert ASCII Code to a Character)
The Char
function converts a decimal ASCII code into its associated character. This function supports returning any of the standard 128 characters assigned an ASCII code.
Syntax
Char(
Argument
)
Where:
Argument
is a fact, metric, column, or constant value that provides an ASCII code in ASCII decimal format. Any value provided outside the range of 0 to 127 causes the Char
function to return a single question mark (?) character. Any other invalid input, such as character strings, causes the Char
function to return null.
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
Char(65)
This example returns A.