INITCAP Function | VantageCloud Lake - INITCAP - Teradata VantageCloud Lake

Modifies a string argument and returns the string with the first character in each word in uppercase and all other characters in lowercase. Words are delimited by white space or characters that are not alphanumeric.

INITCAP is an embedded services system function.

To activate and invoke embedded services functions, see Embedded Services System Functions.

• INITCAP Function Syntax
• INITCAP Argument Types and Rules
• INITCAP Result Type
• Example: INITCAP Function

ANSI Compliance

This statement is a Teradata extension to the ANSI SQL:2011 standard.