TitleCap (Title Capitalization)

The TitleCap function returns a string in which the first letter of every word in the input string is capitalized. All other letters that are not the first letter in a word appear in lower case. This can help to fix capitalization errors in information that is displayed for attribute forms, metrics, and other objects.

A word in a string is any string of alphabetic characters that are separated by a non-alphabetic character such as a space, comma, or number.

To capitalize only the first letter of the first word in a string, see InitCap (Initial Capitalization).

Syntax

TitleCap(Argument)

Where:

Argument is a metric, column, or string value representing the text string.

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

TitleCap("john smith")

This example would return John Smith.

TitleCap("john SMITH")

This example would also return John Smith.