INSERT(string_exp1, start, length, string_exp2)

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_exp, beginning at start.

 

Example:

SELECT INSERT('ABCDEFGHIJ',3,4,'MMMMM') returns ABMMMMMGHIJ