> >
> > are you asking about a query that you would need? if so we need to
> know the
> > table structure , blob, varchar...
> > If you are asking about a presentation layer, then that's not quite
> what
> > this support group is about
> > Alan
> >
>
> I am asking for neither of these.
> I am asking if anyone knows of any fast indexing technology we can use
> on a firebird varchar(40) field to return quick google type responces.
>
> ie. user types in "COCA COLA 2 LITRE"
>
> the system responds in fast time with the closest matching records.
>
> We have 900,000 records in our table.
>
> Kind Regards,
>
> Robert

OK so I think you are asking for fuzzy logic searches... is that correct?
Alan