Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API
Converts the first letter of each word to uppercase and the rest to lowercase.
Syntax
initcap(<string>)
Arguments
Required
<string>: The string to convert.
Returns
Returns a text value with each word capitalized.
Considerations
- Words are sequences of alphanumeric characters separated by non-alphanumeric characters.
- Apostrophes and hyphens within words cause the following character to be capitalized.
Examples
Convert to Title Case
Apply initial capitalization.
SELECT initcap('hi THOMAS') AS result;
Returns 'Hi Thomas'.