>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.

Maybe I'm missing something but LIKE '851251-403%' covers it.