Insert Text Into Text

Jim_KnicelyJim_Knicely Administrator, Moderator, Employee, Registered User, VerticaExpert

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.1.x/HTML/index.htm#Authoring/SQLReferenceManual/Functions/String/INSERT.htm

Have fun!

Sign In or Register to comment.