Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

INSERTSTR function [String]

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.

This function supports NCHAR inputs and/or outputs.

• STUFF function [String]
• String functions

• SQL/2003    Vendor extension.

The following statement returns the value backoffice.

SELECT INSERTSTR( 0, 'office ', 'back' );