Quering between 2 large tables involving wildcards

[Bob Dancer]

I have more Burea Work Comp records which I want to match with records
(1000+) on another table which doesn't have BWC policy numbers. I am trying
to match by name but there are only 100+ exact matches. How can I make one
wildcard query that will apply to all names of both tables?

 

[KARL DEWEY]

How can I make one wildcard query that will apply to all names of both
tables?
Explain a little more. Maybe post sample data would help explain.

 

[Bob Dancer]

Unfortunately the Concatenation will not help me match the present tables.
At this point there are no "unique" keys. The only information I can match
with are the company names. I need some type of universal function that can
match the names of companies on table 1 to those on table 2, maybe some type
of "Like" function. As I described earlier, table 1 has over 900 records and
only 100 had exact matches records in table 2. I need to find a wild card
that can match the other 800. Since there are 800 unmatched names in table 1
it wouldn't be productive to add each one seperately into a query to match
one of the 90,000 in Table 2.

In the long run I am looking for a query that will return all of the records
of Table 1 with updates from table 2 including the policy numbers. If the
wild card could attach or identify the "company" column of Table 1 to the
same column of Table 2 and update the information from Table 2 to 1 (but not
update Table 1 with empty cells from Table 2) that would be a success.
PLease let me know if you have any solutions...my director is getting
impatient!