sql and wildcards

[Incognito44]

I want to build a sql string from a form. I have four dropdown boxes, if there is a selection in a box it gets put in the sql string.
Problem is if there is no selection then my string doesn't work.
to keep it simple lets stick to two pulldowns

Ex.
sql="select * from product where Foundby =" & PullDown1 & Product=" & PullDown2

If PullDown2 has no selection it should be a wildcard but the * doesn't seem to work.

Without building a bunch of if statements with different sql strings is there an approach I can take to still retrieve all data regardless of whether PullDown1 or PullDown2 has a entry.

[Cander]

sql uses % isntead of *
and _ isntead of ?

[Cander]

you also have to use like

Where field like '%ello'

[kidlaley]

sql uses % isntead of *
and _ isntead of ?

you also have to use like
Where field like '%ello'

Cander Beat Me to it!!!

[Incognito44]

Worked like a charm!