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’.