LIKE 'A%' With Other Parameters

mcfly1204

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?

Oct 8 '08 #1

ck9663

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

Oct 8 '08 #2