Specifying a list of fields

When you specify a list of fields, you must specify them adjacent to each other. You can optionally enclose the field references (optionally separated by commas) in parentheses.

These are valid lists of fields:

#17
(#17)
(#17 #22)
(#17, #22)
#17,#22
#17 #22
#17, #22

The search string is found if it is completely contained within one of the specified fields. For example, the following command excludes all records containing the characters “the” (in any mix of uppercase and lowercase) in field #5:

EXCLUDE ALL the #5

The following command finds the next record containing an uppercase letter A in field #8 or #9:

FIND C'A' #8,#9
Fields that are items of a multi-dimensional array share the same field reference number, but are differentiated by the dimension, using a subscript. For example, given the following field references (shown in TABL display format): 
(1,1)    (1,2)    (1,3)    (2,1)    (2,2)    (3,2)
#9       #9       #9       #9       #9       #9
You could specify the following lists of fields: 
FIND bike #9(1,2)
FIND bike (#9(1,3) #9(2,2))
To search all items in the array, specify: 
FIND bike #9