A list can be constructed from raw values by enclosing the raw values in curly braces ({, }). The list must have at least one value. Multiple raw values should be separated by a comma (,). All raw values within the list must be of the same data type.

  • {"Apple", "Banana", "Cherry"} produces a list of Text values: Apple, Banana, Cherry.
  • {1, 2, 3} produces a list of Number values: 1, 2, 3.

Within curly braces, expressions are loosely recognized but may be evaluated in unexpected ways or not evaluated at all. Using expressions within curly braces is strongly discouraged! To use a raw value that might be interpreted as an expression, enclose the raw value in double quotes (").

  • {[Mobile Phone], [Office Phone], [Home Phone]} produces a list of Text values: [Mobile Phone] , [Office Phone] , [Home Phone]. Because the raw values appear to be expressions, the expressions will be checked for validity and may produce errors (e.g., if a column doesn't exist), but these apparent expressions will not be evaluated!
  • {1, (1 + 1), (6 / 2), ROUND(POWER(2, 2)), ROUND(SQRT(25))} produces a list of Number values: 1, 1, 1, 6, 2, 4, 5. Note that these expressions are recognized but do not produce the expected results! See also: POWER(), ROUND(), SQRT().
  • {"(1 + 1)", "(6 / 2)"} produces a list of Text values: (1 + 1), (6 / 2). Note the apparent expressions are not recognized as expressions within the quotes.

See Also

List Expressions, List from Expressions, List from Table-Column Reference, LIST()

Did this answer your question?