> ## Documentation Index
> Fetch the complete documentation index at: https://www.integrate.io/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# ETL: INITCAP

> Capitalize the first letter of each word in a string and lowercase the rest. Word delimiters include whitespace, hyphen, apostrophe, and period.

## Description

Capitalizes the first letter of each word in a string and lowercases the rest. Words are delimited by whitespace, hyphen, apostrophe (straight or curly), or period.

## Syntax

`INITCAP(string_expression)`

## Examples

`INITCAP('mary-jane o\'brien')` returns 'Mary-Jane O'Brien'.

`INITCAP('JOHN SMITH')` returns 'John Smith'.

`INITCAP('hello world')` returns 'Hello World'.

## Return value datatype

String

## Impact of null value

If input is null, returns null.