4D v16

INSERT

Home

 
Home
4D v16
4D - SQL Reference
Functions
INSERT

INSERT  


 

 

Command INSERTINSERT (arithmetic_expression, arithmetic_expression, arithmetic_expression, arithmetic_expression)

The INSERT function inserts one string into another at a given position. The first arithmetic_expression passed is the destination string. The second arithmetic_expression is the index where the string passed in the fourth arithmetic_expression will be inserted and the third arithmetic_expression gives the number of characters to be removed at the given insertion point.

Example  

This example will insert "Dear " in front of the first names in the PEOPLE table:

SELECT INSERT (PEOPLE.FirstName,0,0,’Dear ‘) FROM PEOPLE;

Vorige Seite
Nächste Seite

 
EIGENSCHAFTEN 

Produkt: 4D
Thema: Functions

 
GESCHICHTE 

 
ARTIKELVERWENDUNG

4D - SQL Reference ( 4D v16)