ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

INSERTSTR function [String]

Function 

Inserts a string into another string at a specified position.

Syntax 

INSERTSTR (
integer-expression,
string-expression-1,
string-expression-2 )

Parameters 

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.

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Not supported in Adaptive Server Enterprise.

See also 

STUFF function [String]

Example 

The following statement returns the value backoffice.

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