This will work unless my lookup part number is 851251-4A.

What I would like is somthing like this to work

Select myFields From myTable Where partno In('851251-403','851251-403A%','851251-403B%') but I don't know how to make wildcards work in the Where In clause.