>
> 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