String Functions

String functions perform various actions that modify the characters returned for a string of characters. While string functions can be used to create metrics, a more common use case for these functions is in the creation of attribute forms. For example, these functions can aid in the creation of attribute forms by combining multiple columns of information, capitalizing the first letter of a column, removing or returning select characters of a column, and so on. For information on creating attributes and attribute forms, see the Project Design Help.

The MicroStrategy Analytical Engine does not calculate string functions; they are processed by the database. For information on which string functions are supported for your specific database, see MicroStrategy and Database Support for Functions, and search in the section corresponding to your database. String functions for which your database does not include SQL syntax support cannot be calculated in your environment.

This section of the document includes information and examples on the data returned by the function.