WayneS (5/2/2008)
Since the question clearly states:The condition should not use both IN and OR operators.
use could use:
where DatePart(m, ) IN (1,3,4,5,7,8)
OR is not used, so since they BOTH aren't used, this is valid.
Exactly the answer I was about to give. 🙂 I figured the question had to have been misworded, it's a complete no-brainer as is.
Ron Moses
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown