Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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

SarahLSarahL Administrator
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.