I'd never try to use some clever "all the months without 'e' in their name", so I just took the list as having some business-rule basis, and decided that, if I needed to implement it, I could easily use a CTE, derived table, or temp table, with those numbers in it, joined to the table being queried. No "in", no "or".
Yeah, the answer given is based on the silly "how many 2-cent stamps in a dozen", or "do they have the 4th of July in England", type process, but that doesn't make the answer I came up with technically inaccurate.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon