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.
- 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.
- A value for start of less than 1 (zero or negative) specifies a position to the left of the beginning of string-1.
- 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