Progress
Database Design
Guide


Progress Defaults

The default rules defined by the Progress 4GL are as follows:

These rules apply to both the text in a word index field and text in a CONTAINS clause. For example, if you type “John’s” in a CONTAINS clause, it is treated the same as “Johns”. If you type “8:30pm” it is treated as two words: 8 and 30pm. Therefore, a record containing the string “8:30pm” will be found, but so could a record containing “8 Capital St. at 7:30pm.” As with indexes, separators and terminators are ignored for the second part of the CONTAINS clause. This means that the string entered in the database matches the string entered after the CONTAINS clause.


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