The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Use the OVERLAY Function to Easily Insert a String Into Another String

edited May 2018 in Tips from the Team

Jim Knicely authored this tip.

The OVERLAY function returns a VARCHAR value representing a string having had a substring replaced by another string.

Example:

dbadmin=> SELECT OVERLAY('See ya @ the Deep Dive Meetup tomorrow in St. Louis, MO!' PLACING ' Vertica' FROM 13 FOR 0) AS "Awesome Event on 05/15/2018";
                   Awesome Event on 05/15/2018
------------------------------------------------------------------
See ya @ the Vertica Deep Dive Meetup tomorrow in St. Louis, MO!
(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.