The LIST() function constructs a list from any combination of raw values, column values, and expressions. The values in the resulting list will be in the order they were given to the LIST() function.

  • LIST("Apple", "Banana", "Cherry") produces a list of Text values: Apple, Banana, Cherry.
  • LIST([Mobile Phone], [Office Phone], [Home Phone]) produces a list of phone numbers from three column values of the current row.
  • LIST(1, (1 + 1), (6 / 2), ROUND(POWER(2, 2)), ROUND(SQRT(25))) produces a list of Number values: 1, 2, 3, 4, 5. See also: POWER(), ROUND(), SQRT().
  • LIST() produces an empty list.

See Also

Expressions: The Essentials, List Expressions, List from Table-Column Reference, List from Values, LIST()

Did this answer your question?