--
Jim Poe ( jpoe_at_fulcrumit.com )
> One could automate this for the user -- parsing out spaces and
> converting then into '%'. Not hard programming.
>
> I have written code that did lookup based on the initial letters -->
> looking for 'ACME' as company_name like 'A%C%M%E%'. Again for small
> tables (~10,000 rows) the database was more than fast enough especially
> if the company_name was part of an index. Again not hard programming in
> forms.
Hmm, maybe I am not being creative enough with the 'like' syntax. What is
'A%C%M%E%' saying?
>
> Approach two is to generate the company word index table/index. You can
> create the rows by doing the parsing and inserting the data into the
> table. You might want to develop triggers -- to add/update/delete rows
> in the index table when you add/update/delete company rows. Not hard
> programming -- but a little bit of work.
I thought about this, and I think it may be the closest match to the cross
reference index.
>
> By the way what database has this cross referencing built-in?
> --
It is called Advanced Revelation, a Pick derivative.
Thanks
Received on Fri Dec 01 2000 - 17:42:16 CST
