Concatenates one or more strings into one large string.
STRING( string-expression [, ... ])
string-expression The string to be evaluated.
If only one argument is supplied, it is converted into a single expression. If more than one argument is supplied, they are concatenated into a single string.
LONG VARCHAR
LONG NVARCHAR
LONG BINARY
Numeric or date parameters are converted to strings before concatenation. The STRING function can also be used to convert any single expression to a string by supplying that expression as the only parameter.
If all parameters are NULL, STRING returns NULL. If any parameters are non-NULL, then any NULL parameters are treated as empty strings.
SQL/2003 Vendor extension.
The following statement returns the value testing123.
SELECT STRING( 'testing', NULL, 123 ); |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |