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?

[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