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?

thank you

mike harry