find problem 1

[nycdata]

Hi,

I am trying to design a search engine. Some parts of it work some don't. I need to be able to look for searchitem in two fields and return all the matching records.

Also, the searchitem does can be a sub string of item found in the two fields.

Foe eg: if you search for PC, then one of the item founds could be

HP PCs or 500 PCs or PC

Any help will be greatly appreciated

 

[hymn]

This seems to be one of the best examples at the thread below
thread702-563930

Hope this helps
Hymn

 

[nycdata]

Thanks!!