Specifying a list of columns

When you specify a list of columns, you must either:
  • Enclose the column references (optionally separated by commas) in parentheses, or
  • Separate the column references with commas but without any intervening spaces.

These are valid lists of columns:

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

These are invalid lists of columns:

#17 #22
#17, #22

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

EXCLUDE ALL the #5

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

FIND C'A' #8,#9