Inserts a string into another string at a specified position.
Parameter |
Definition |
---|---|
numeric-expression |
The position after which string-expression2 is to be inserted. Use zero to insert a string at the beginning. |
string-expression1 |
The string into which string-expression2 is to be inserted. |
string-expression2 |
The string to be inserted. |
LONG VARCHAR
The result data type is a LONG VARCHAR. If you use INSERTSTR in a SELECT INTO statement, you must have an Unstructured Data Analytics Option license or use CAST and set INSERTSTR to the correct data type and size.