Progress
Programming
Handbook


The CONTAINS Operator, Word Indexes, and Word-break Tables

You can use the CONTAINS operator of the WHERE option of the record phrase to query a Progress database. For example, the following query displays each item record of the sports database whose cat–description field contains the string “hockey”:

FOR EACH item WHERE cat-description CONTAINS "hockey": 
  DISPLAY item. 
END. 

Using the CONTAINS operator involves word indexes and word-break tables. This section explains why and tells you how to use word indexes and word-break tables. Specifically, the section covers:

NOTE: Word indexes and word-break tables have international implications. To understand these implications, first read this section, then see the Progress Internationalization Guide .


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095