Hi Si, I would be interested in this SP.

Dennis

Si Carter wrote:

>
>
> > -----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
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
>
> ------------------------------------------------------------------------
> YAHOO! GROUPS LINKS
>
> * Visit your group "firebird-support
> <http://groups.yahoo.com/group/firebird-support>" on the web.
>
> * To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
> <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>
> ------------------------------------------------------------------------
>