INSERTSTR function [String]

Inserts a string into another string at a specified position.

INSERTSTR ( numeric-expression, string-expression1, string-expression2 )

numeric-expression The position after which string-expression2 is to be inserted. Use zero to insert a string at the beginning.

string-expression1 The string into which string-expression2 is to be inserted.

string-expression2 The string to be inserted.

The following statement returns the value backoffice.

SELECT INSERTSTR( 0, 'office ', 'back' ) FROM iq_dummy

Sybase Not supported in Adaptive Server Enterprise. The STUFF function is equivalent and is supported in both Adaptive Server Enterprise and Sybase IQ.