Wildcard Query between two tables

[iwantoh]

I have two tables, one is transaction table and the other one is a list of part number.

I need to run a query on these table by connecting the part number field on both tables. Since part numbers in the other table are not well formated, the only way to query the two table on part number but using wildcard from the other table. Is there away to do this?

Thanks for any help,

Iwanto