INSRT

Returns a string obtained by inserting a string into another string, in front of the indicated position.

Syntax

INSRT(String1, String2, Location)

String1 is the string to be inserted. String2 is the string into which String1 is inserted. Location is the location in String 1 in front of which String 2 is inserted.

Examples

This example returns 'ALEA IACTA EST':

INSRT('IACTA', 'ALEA EST', 5)

This example returns 'ALEA IACTA EST':

INSRT('ALEA ', 'IACTA EST', 1)