Find Problem

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

Check out the LIKE command, e.g.

select * from tblThing where (Field1 like '*' & searchitem & '*') or (Field2 like '*' & searchitem & '*')