SQL quick question... searching for a variable within a string

**sepple** · 06-15-2009, 05:43 PM

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]& "%"

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

Thanks in advance,

Stephen

**davidj** · 06-16-2009, 02:47 AM

use a LIKE instead of an EQUALS

Code:

 WHERE  COMPANY_NAME LIKE "%company name%"

**sepple** · 11:24 AM

Turns out...

WHERE COMPANY_NAME = "*" & [Company Short Name]& "*"

Works great....thanks