Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Capitalize Only the First Letter of Each Word

SarahLSarahL Administrator
edited May 2018 in Tips from the Team

Jim Knicely wrote this tip.

A few years ago, when I was an Oracle DBA, a client thought they’d stump me by asking how they could capitalize only the first letter of each word for a given input. I immediately said try the INITCAP function. She was amazed. Guess what?? Vertica has the same function!

Example:

dbadmin=> SELECT INITCAP('vertica is amazing');
      INITCAP
--------------------
Vertica Is Amazing
(1 row)

Have Fun!

Sign In or Register to comment.

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.