# `INITCAP`

**Applies to:** ✅ Data 360 SQL ✅ Tableau Hyper API

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

## Syntax

```sql
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.

```sql
SELECT initcap('hi THOMAS') AS result;
```

Returns `'Hi Thomas'`.

## Related Documentation

- [String Types](/docs/data/data-cloud-query-guide/references/dc-sql-reference/string.md)