|
|
|
|
|
|
The PASTE Function
Syntax for the PASTE function:
string-1 and string-2 are character or binary string expressions.
string-1 and string-2 must be of the same type, i.e. either both character or both binary.
start and length are integer value expressions.
Rules:
- The length characters in string-1, starting from position start are deleted from string-1. Then string-2 is inserted into string-1, at the "point of deletion". The resulting character or binary string is returned.
- If the value of length is positive, the length characters to the right of start are deleted. If the value of length is negative, the length characters to the left of start are deleted.
The "point of deletion" is where the cursor would be if you had just used a text editor to select the characters, as described, and performed an edit-cut operation.
- A value for start of less than 1 (zero or negative) specifies a position to the left of the beginning of string-1.
It is possible that the specified "deletion" may not actually affect any of the characters of string-1, in which case the paste operation produces the effect of a prepend.
- If the value of any operand is NULL, then the result of the function is NULL.
 Upright Database Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 dbtechnology@upright.se |
|
|
|
|
|
|
