Columns
Expression Syntax: Columns
Columns can be represented as vectors within expressions by enclosed the query and column name in single square brackets. A column name must be preceded by the name of the query it belongs to using the dot “.” character. The query and column names can be placed within the same pair of brackets or in separate bracket pairs. You can use a column in this manner exactly as you would any vector data.
| Expression | Result |
|---|---|
| [SampleQuery.SampleColumn] | (contents of SampleColumn) |
| [SampleQuery].[SampleColumn] | (contents of SampleColumn) |