> -----Original Message-----
> That is the normal way of doing it in Firebird. Obviously an
> index can only help a "containing" query if it can be
> transformed to a "Starting with".

Another method which might work is to store a soundex of the customer name
and search on that.

> So the suggestion is to have a generic words table, a
> customer table, and a table linking customers and words.

If your interested in doing it this way, I have developed a stored procedure
which takes a block of text (varchar) and returns all individual words (or
breaks the text in other combinations CSV etc), this could save a lot of
time/bandwidth when posting new records.

Rgds

Si Carter
http://www.fbtalk.net/ - Web Based Firebird Forum
http://www.tectsoft.net/ - Homepage