sepple

I am trying to use Microsoft Access to match company names.

I want "Pepsi" to find all of the following:
The Pepsi Company
Pepsi, Inc.
Pepsi

[CODE]WHERE COMPANY_NAME = "%" & [Company Short Name]& "%"[CODE]

Please help, I am struggling and can't find any help online.[/

Thanks in advance,

Stephen