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

Insert Text Into Text

Jim_KnicelyJim_Knicely Administrator
edited January 31 in Tips from the Team

The built-in Vertica INSERT function injects a character string into a specified location in another character string.

Example:

dbadmin=> SELECT insert('Vertica is AWESOME!', 12, 0, 'EXTREMELY ');
            insert
-------------------------------
Vertica is EXTREMELY AWESOME!
(1 row)

Helpful Link:
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/Functions/String/INSERT.htm

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.