Product Documentation

Appearance

All platforms

INITCAP ​

Capitalize the first letter of each word in a character string.

A word in this context is any alphanumeric string. Non-alphanumeric characters, such as underscores, apostrophes, punctuation marks, and dollar signs, are all treated as word separators.

INITCAP(string)

For example:

premdb=# select initcap('hello my name is Bob') from sys.const;
      initcap        
----------------------
 Hello My Name Is Bob
(1 row)
yellowbrick=# select initcap('hello_my_name_is_bob') from sys.const;
      initcap        
----------------------
 Hello_My_Name_Is_Bob
(1 row)