The Vertica Forum is getting a makeover! The site will be undergoing maintenance from Tuesday 8/13 to Friday 8/16. We appreciate your patience and cooperation during this time.

Capitalize Only the First Letter of Each Word

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.