Re: Free format text searches ?

"Steven Wort" <SWort@globalnet.co.uk> wrote: :Can anyone tell me how to do free format text searches across multiple :columns and tables. :What I am looking for is the ability to automatically generate a keyword :index on textual data as it is entered to the DB, so that subsequent :searches to are very fast? :I have done something in MS SQL server using a keyword index generated on :an overnight process, but would like something that is a little more "built :in", that would be kept up to date as data is entered. Look at Universal Server from Informix. It will have this functionallity. It's planned initially to be available in December this year. If you need something in the meantime the Illustra engine (also from Informix) may be an alternative. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org