INSERTSTR function [String]

Function

Inserts a string into another string at a specified position.

Syntax

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

Parameters

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 result data type of an INSERTSTR function is a LONG VARCHAR. If you use INSERTSTR in a SELECT INTO statement, you must have an Unstructured Data Analytics Option license or use CAST and set INSERTSTR to the correct data type and size.

See “REPLACE function [String]”.

Example

The following statement returns the value “backoffice”:

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

Standards and compatibility

SQL Vendor extension to ISO/ANSI SQL grammar.

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