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 Server - SQL Reference > SQL functions > Functions > 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.