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


Insert Text Into Text — Vertica Forum

Insert Text Into Text

Jim_KnicelyJim_Knicely - Select Field - Administrator
edited January 2019 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.