LIST function [Aggregate]

Returns a comma-delimited list of values.

Syntax

LIST(
[DISTINCT] string-expresssion
[, 'delimiter-string']
[ORDER BY order-by-expression [ ASC | DESC ], ... ] )

Note:

CIS functional compensation performance considerations apply.

The LIST function [Aggregate] is a SQL Anywhere function. See SQL Anywhere 11.0.1 > SQL Anywhere Server - SQL Reference > Using SQL > SQL functions > SQL functions (E-O) > LIST function [Aggregate].

Returns

LONG VARCHAR

Note:

The result data type is a LONG VARCHAR. If you use LIST in a SELECT INTO statement, you must have an Unstructured Data Analytics Option license or use CAST and set LIST to the correct data type and size.