Reference Guide > TDV Support for SQL Functions > Character Functions > INSERT
 
INSERT
Returns a character string where length characters have been deleted from string_exp1, beginning at start, and where string_exp2 has been inserted into string_exp1, beginning at start.
Syntax
INSERT( string_exp1, start, length, string_exp2)
Example
select INSERT('Sunday',1,3,'Mon')
Returns: Monday