Returns a character string where length number of characters have been deleted from string_exp1 beginning at start_pos, and string_exp2 has been inserted into string_exp1, beginning at start_pos.

Syntax

INSERT( string_exp1 , start_pos , length , string_exp2 )

Notes

  • The string_exp can be type fixed‑length or variable-length CHARACTER.
  • The start_pos and length can be of data type INTEGER, SMALLINT, or TINYINT.
  • The result string is of the type string_exp1.
  • If any of the argument expressions evaluate to NULL, the result is NULL.
  • If start_pos is negative or zero, the result string evaluates to NULL.
  • If length is negative, the result evaluates to NULL.
  • string_exp1 and string_exp2 and the result can contain multi-byte characters. This is determined by the character set of the SQL server. The length argument specifies a number of characters.

Example

This example illustrates the INSERT function:

SELECT INSERT(last_name,2,4,'xx')
     FROM customer 
     WHERE last_name = 'Goldman'; 
 INSERT LAST_NAME,2,4,XX)
------------------------
Gxxan              
 1 record selected

The two letters ‘o' and ‘l' are deleted from the name ‘Goldman' in the last_name column, and the letters ‘xx' are inserted into the last_name column, beginning at the fourth character, overlaying the letters ‘d' and ‘m'.

Compatibility

ODBC compatible