Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Reference » Using SQL » SQL functions » Alphabetical list of functions

 

STRING function [String]

Concatenates one or more strings into one large string.

Syntax
STRING( string-expression [, ... ])
Parameters
  • 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.

Remarks

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.

See also
Standards and compatibility
  • SQL/2003   Vendor extension.

Example

The following statement returns the value testing123.

SELECT STRING( 'testing', NULL, 123 );