INITCAP

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Converts the first letter of each word to uppercase and the rest to lowercase.

1initcap(<string>)

• <string>: The string to convert.

Returns a text value with each word capitalized.

• Words are sequences of alphanumeric characters separated by non-alphanumeric characters.
• Apostrophes and hyphens within words cause the following character to be capitalized.

Apply initial capitalization.

1SELECT initcap('hi THOMAS') AS result;

Returns 'Hi Thomas'.

• String Types