>The 2.6 application does just that(save every word in a separate table with an index) but what a hassle. It is also a Lot of effort to avoid the noise words ex. the, a, and, ...
The problem is, there is simply no alternative. You can index on padr(MyMemo, 100), but you can't create an index that optimizes searches on any part of the memo, without using separate tables, word-by-word.
PHdBASE apparently helped you do just that, but I am not sure whether they are still in business.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
