With a few minor tweaks that script worked.

Thanks so much.

I'm using the legacy vendors to create the LIKE statements. I'm not linking the 2 tables. Should I? If you need a legacy table just use a bogus name [legacy_vendors].

This is a sample. This query will run w/o issue but I need to include a heck more LIKE statements.

SELECT Apvenaddr.[VENDOR-LOC], Apvenaddr.[VENDOR-NAME], Apvenaddr.VENDO RNAME, Apvenaddr.ADDR1 , Apvenaddr.ADDR2 , Apvenaddr.ADDR3 , Apvenaddr.ADDR4 , Apvenaddr.[CITY-ADDR5], Apvenaddr.[STATE-PROV], Apvenaddr.[POSTAL-CODE]
FROM Apvenaddr
WHERE (((Apvenaddr.VE NDORNAME) Like "ADELEKEKAM *" Or (Apvenaddr.VEND ORNAME) Like...

I reaaly need some help with this. I'm trying develop a method for listing possible duplicate vendors. The problem is I have tons of legacy vendors that need to be mapped to the current ERP. I have been using multiple LIKE statements with the first 10 characters of the legacy vendors name against the current ERP vendors. Then I use the output listing to manually map the the two. This is fine for only 1000 vendors but I have over 13k unique legacy...