search for x where y Like..

  • Thread starter Thread starter Mettá
  • Start date Start date
M

Mettá

I have a db search based on a number of fields, however I have hit a
problem, I need to specify = rather than LIKE but for some reason if returns
no records if I change like to equals

....WHERE (Descrip LIKE '%"&Search& "%' AND Cnty LIKE '%" &Search2& "%' AND
Pcd1 LIKE '%" &Search3& "%')

If I change the last part to Pcd1= ' %" &Search3&& "%')

The search fails?? Yet Search3 has a corresponding value

Any ideas what I am doing wrong?

Thanks M
 
Back
Top