---
schema_version: "1"
id: d61bbb1ac6bb21663adaf0c0e3c66e82ebd8e22ab0f6268627de5eb56f67a507
title: INITCAP
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-query-guide/references/data-cloud-sql-reference/scalar-func/string-func/initcap.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/initcap.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 7af68ed03dbc5130df8e3d655ffe1986b43e02721516593cae0dc2596cdcc9c8
products:
  - Data 360 Query Guide
  - Data 360 Developer Documentation
---
# `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](https://developer.salesforce.com/docs/data/data-cloud-query-guide/datatype/string.md)