Release 10.1A: OpenEdge Development:
Programming Interfaces

> ## 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 OpenEdge 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:

> - Understanding the `CONTAINS` operator, word indexes, and word-break tables.

> - Using word indexes.

> - Using word-break tables.

> - Using the `CONTAINS` operator.

> - Word indexing external documents.

> - Word indexing non-OpenEdge databases.

> Note: Word indexes and word-break tables have international implications. To understand these implications, first read this section, then see the OpenEdge Development: Internationalizing Applications .

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