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!
