ASA SQL Reference
SQL Functions
Alphabetical list of functions
Concatenates one or more strings into one large string.
STRING ( string-expression [, ...] )
string-expression A string.
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.
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/92 Vendor extension.
SQL/99 Vendor extension.
Sybase Not supported by Adaptive Server Enterprise.
The following statement returns the value testing123.
SELECT STRING( 'testing', NULL, 123 )