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.