Partial Match query design

Tech-Archive recommends: Speed Up your PC by fixing your registry

I am trying to run a query where I am looking at data in a customer table and
looking for matching records in a vendor table basing that match on the
vendor/customer name. I have some records where I may have a partial match
(ABC Company vs ABC Company, Inc.). If there are matches that are this close,
I would like the record returned.

Any ideas?
.

Relevant Pages