Index problems

[Kenneth Brody]

Tim Fischer wrote:
[...]
> > > 1- T1)Name = "c&p transport"
> > > 2- T1)DBA Name = ""

Search for "c&p" "does not come up".  Search for "c&p t" does.

[...]
> > Can you explain what you mean by "does not come up anywhere
> > near the results"?  Where does it come up?
> 
> I'm not really sure on this.  With well over 20,000 records in this table I
> haven't found it yet.  I didn't want to say that it's not coming up at all
> simply because I a) doubt that and b) can't prove that.

What _does_ come up when you try "c&p"?

How, exactly, are you looking for the record?  (ie: a lookup, at *clerk's
"index selection" prompt, some other method?)

[...]

-- 
+-------------------------+--------------------+-----------------------------+
| Kenneth J. Brody        | www.hvcomputer.com |                             |
| kenbrody/at\spamcop.net | www.fptech.com     | #include <std_disclaimer.h> |
+-------------------------+--------------------+-----------------------------+