Link to home
Start Free TrialLog in
Avatar of mickeyshelley1
mickeyshelley1Flag for United States of America

asked on

Modify Sql Query ToSearch Any Part Of The Field

I need to modify the following query so that it will find John Smith or John or Smith or John Henry Smith in text20
I need to modify the following query so that it will find John Smith or John or Smith or John Henry Smith
 
 
 
SELECT Customer.CustNo, Customer.Customer, Customer.Address, Customer.City, Customer.State, Customer.ZipCode, Customer.Phone, Customer.Contact, Customer.CustOther, Customer.Art
FROM Customer
WHERE (((Customer.Customer) Like [Forms]![Customer]![text20]));

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Kevin Cross
Kevin Cross
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mickeyshelley1

ASKER

Thanks that did the trick
You are welcome.