>I have a database of 500,000 records, I need to do content searching through the memo fields for certain words, I also need to incorporate searching on some non memo fields.
>does anyone know of any tools or the best way to do this?
>
look at PHDbase III for full word indexing to memo fields
you can test it here in these pages (click on the search icon)

HTH

Arnon