INITCAP

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

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

  • <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.

Returns 'Hi Thomas'.