We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now

Capitalize Only the First Letter of Each Word — Vertica Forum

Capitalize Only the First Letter of Each Word

[Deleted User] Administrator

May 2018 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!

or Register to comment.