RE: fast search or scan for words in selected field

[Mike Barton <Mike.Barton@xxxxxxxxxxxxxxxxx>]

> Hi,
> 
> We currently have customer master file which has customer company name
> field. Customer company name field is 20 long, if this field has "MY
> TEST COMPANY" description saved then we have another program which will
> make three records for this records in our custom file, first records
> with their customer number and name  will have "MY" and second record
> will have "TEST" and the third record will have "COMPANY". We have to do
> this for fast search by any description given by customers.  Our files
> are getting huge and want to know if there is another quick way to
> handel this on green screen. I thank you for your time.
> 
> Wayne

Wayne
        this is similar to how we do our searches.

We do however limit the minimum length to 3 characters
so we wouldn't have a record for MY.
Also we limit the search word to 6 characters max.

The files are long but not necessarily huge :)

Mike
###########################################

This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
For more information, connect to http://www.F-Secure.com/


This communication and the information it contains: - (a) Is intended for the 
person(s) or organisation(s) named above and for no other person(s) or 
organisation(s). Access to this mail by anyone else is unauthorised. (b) Is 
confidential, and may be legally privileged or otherwise protected in law. 
Unauthorised use, circulation, copying or disclosure of any part of this 
communication may be unlawful. (c) May be susceptible to interference, and 
should not be assumed that it has come in its original form and/or from the 
stated sender or PinkRoccade UK accepts no responsibility for information, 
errors or omissions in this e-mail or use or misuse thereof or any act done or 
omitted to be done in connection with this communication. If you are not the 
intended recipient, please inform postmaster@xxxxxxxxxxxxxxxxx immediately and 
delete it and all copies from your system.