Where clause problems

[link9]

I need to select a recordset from an access database (with asp - vbscript) where a certain field (SVP) can equal several different things, but not necessarily contiguous. Below is the flawed select statement I have. If anyone can correct it for me, I would GREATLY appreciate it.


"select * from demographics where SVP = 51 or SVP = 53 or SVP = 56 and VPO = 65"

I'm fairly new at sql, so please help!

Thank you,
Paul Prewett

 

[culshaja]

The best thing to do is use brackets, because the AND has a greater binding power than the OR statements.
What you are issuing is:

"select * from demographics where SVP = 51 or SVP = 53 or (SVP = 56 and VPO = 65)"

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305