mickeyshelley1
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]));
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You are welcome.
ASKER