Vertica Quick Tip: Capitalize Only the First Letter of Each Word

Posted May 1, 2018 by Soniya Shah, Information Developer

City in Blur Motion
This blog post was authored by Jim Knicely. 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!