Not sure if I totally understand. But you could look at using quick searches and the matches operator.
--- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@...> wrote:
>
> Hi,
> ÂÂ
> My marketing department has asked me to assist with their searches.
> ÂÂ
> They have told me that:
> ÂÂ
> We need to be able to search any part of a field i.e. input “meadow†and it would bring up “The Meadow House†or I M Meadowcroft Plc. It would also be nice to be able to narrow down that search itself once the info is there.
> ÂÂ
> We have in excess of 40k customers/prospects on vantage and Vantage's standard search when searching for a customer is, as you know, to search for any companies starting with e.g. 'the', but it then list every single company below 't' in the alphabet, such as u, v, w etc.
> ÂÂ
> They need to be able to perform a search on a company name, where it only brings up the information requested and not everything else that follows in the alphabet.
> ÂÂ
> As far as I can see, if you were searching for e.g. The Meadow House, but you only typed in Meadow House, Vantage wouldn't return the result as it is looking for a company name starting with MEADOW, so it instantly starts searching in the 'M' section.
> ÂÂ
> Does anyone know of a way of getting Vantage to search for part of a company name rather than the beginning of the company name?
> ÂÂ
> We need it to search the middle section or only part of a company name and return results containing the searched words.
> ÂÂ
> For example if we searched for 'mea', it would return all company names containing 'mea' e.g.
> ÂÂ
> The Meat Company
> The Meadow House
> I M Meadowcroft Plc
> Mear & Co.
> The Meaning Ltd
> ÂÂ
> etc.
> ÂÂ
> Any assistance would be greatly appreciated.
> ÂÂ
> Thanks,
> ÂÂ
> CHRIS THOMPSON
>
>
>
>
> [Non-text portions of this message have been removed]
>