using Like function 1

[stasJohn]

I'm using MS Access 2003 (visual basic 6.3).

I'm running through a database to find duplicates. Basically, I want "fakecompany" and "fakecompany, inc" to be returned as a match.

SELECT db1.company, db2.company FROM db1, db2 WHERE db1.company LIKE %db2.company%

Obviously the above sql does not work. Is there some way to accomplish it?

Thanks in advance

 

[GingerR]

SELECT db2.Company, db1.CompanyFROM db2, db1
WHERE (((db1.Company) Like [db2].[Company] & "*"))

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[stasJohn]

Thank you GingerR, that worked like a charm!