Connecting Tech Pros Worldwide Forums | Help | Site Map

LIKE 'A%' With Other Parameters

Familiar Sight
 
Join Date: Jul 2007
Posts: 180
#1: Oct 8 '08
I am attempting to perform a query where I pull all names that begin with 'A' along with a couple other parameters. If I just look for names that begin with 'A', everything goes as planned, but when I add other stipulations, the previous is now void. How can I get around this?

ck9663's Avatar
Expert
 
Join Date: Jun 2007
Posts: 1,925
#2: Oct 8 '08

re: LIKE 'A%' With Other Parameters


You did not post your code so I'm assuming there's an OR in your WHERE clause. You should either use AND or use parenthesis to group your conditions.

-- CK
Reply