Inserts a string into another string at a specified position.
INSERTSTR( integer-expression, string-expression-1, string-expression-2 )
integer-expression The position after which the string is to be inserted. Use zero to insert a string at the beginning.
string-expression-1 The string into which the other string is to be inserted.
string-expression-2 The string to be inserted.
LONG VARCHAR
This function supports NCHAR inputs and/or outputs.
SQL/2008 Vendor extension.
The following statement returns the value backoffice.
SELECT INSERTSTR( 0, 'office ', 'back' );