INITCAP

​

Syntax

​

Scalar

initcap(value)

​

Arguments

​

Returns

• Type: STRING
• Possible values: Title-cased text.
• NULL behavior: Returns NULL for NULL input.

​

Properties

​

Usage notes

• Non-Snowflake word boundaries are non-alphanumeric. Snowflake uses fixed ASCII delimiters excluding apostrophe, backtick and equals.

​

Examples

​

Typical behavior

SELECT initcap('hello WORLD') AS "value";

​

Snowflake dialect word boundaries

• Requires the Snowflake SQL dialect configured with DATABASE_TYPE=snowflake.

SELECT initcap('a=b=c') AS "value";

​

Limitations

• Takes one STRING argument. A custom delimiter argument is not supported.