──INSERT(new,target─┬─────────────────────────────┬─)───── └─,─┬───┬─┬──────────────────┬┘ └─n─┘ └─,─┬──────┬─┬────┬┘ └length┘ └,pad┘
INSERT inserts the string new, padded to length length, into the string target after the n th character. If specified, n must be a nonnegative whole number. If n is greater than the length of the target string, padding is added there also. The default pad character is a blank. The default value for n is 0, which means insert before the beginning of the string.
Here are some examples:
INSERT(' ','abcdef',3) -> 'abc def' INSERT('123','abc',5,6) -> 'abc 123 ' INSERT('123','abc',5,6,'+') -> 'abc++123+++' INSERT('123','abc') -> '123abc' INSERT('123','abc',,5,'-') -> '123--abc'