search for x where y Like..

[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

 

[Bob Lehmann]

Remove the wildcards when using "="...
Pcd1= '" & Search3 & "')

Bob Lehmann

 

[Mettá]

Thanks.
M

--
---

Remove the wildcards when using "="...
Pcd1= '" & Search3 & "')

Bob Lehmann