4D v13.4INSERT |
||||||||||||||
|
4D v13.4
INSERT
INSERT
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. This example will insert "Dear " in front of the first names in the PEOPLE table: SELECT INSERT (PEOPLE.FirstName,0,0,’Dear ‘) FROM PEOPLE; |
PROPERTIES
Product: 4D INDEX |
||||||||||||