For the AVM to process a query that uses the CONTAINS operator, the field mentioned in the WHERE option must participate in a word index. For example:
FOR EACH Item WHERE Item.CatDescription CONTAINS "hockey":
DISPLAY Item.
END.
The AVM looks for the word indexes associated with the Item record and its CatDescription field. If no such word indexes are found, the AVM reports a run-time error. Otherwise, the AVM uses the word indexes to retrieve the Item records whose CatDescription field contains the string hockey.
