Returns the concatenation of a given string expression for all selected rows.

Syntax

---

LIST([DISTINCT] [ORDERED] <StringExpression> [USING <Delimiter>])
LIST([DISTINCT] [ORDERED] <StringExpression> [, <Delimiter>])

<StringExpression> =

Type of:

CHAR
VARCHAR
CLOB

<Delimiter> =

Type of:

CHAR
VARCHAR
CLOB

Returns

---

CLOB

Usage

---

The LIST function returns the concatenation of a given string expression for all selected rows. The selected rows can be grouped into logical sub-sets by using the GROUP BY clause of the SELECT statement. Any time the string expression is NULL, it is excluded from the concatenation operation. If the delimiter expression is not specified, then it defaults to using a comma (,).

Use the DISTINCT clause to specify that the list concatenation will only use distinct values when creating the result.

The ORDERED clause indicates that you wish to have the listed values in the result sorted in ascending order.

Examples

---

SELECT LIST(Company) AS CompanyNames
FROM Customer

SQL 2003 Standard Deviations

---

This function deviates from the SQL 2003 standard in the following ways: