There are two ways to refer to the data in a table: a cell reference (which yields the data in a single cell); and a row reference (which yields a string that contains all the data in the row).

 

You can reference a row as row ROWNUM of TABLE_NAME or use the built-in function textual row ROWNUM of TABLE; for example:

 

textual row 17 of Departments 

textual row (MyCar+2) of AutoLot

 

Certain statements also require a column reference, but you must always refer to data by either a row or cell reference. The general form of a column reference is:

 

column {NAME | NUMBER} of TABLE_NAME