Inserts a string into another string at a specified position.
INSERTSTR( integer-expression, string-expression-1, string-expression-2 )
integer-expression The position after which the string is to be inserted. Use zero to insert a string at the beginning.
string-expression-1 The string into which the other string is to be inserted.
string-expression-2 The string to be inserted.
LONG VARCHAR
This function supports NCHAR inputs and/or outputs.
SQL/2003 Vendor extension.
The following statement returns the value backoffice.
SELECT INSERTSTR( 0, 'office ', 'back' ); |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |