rbarryyoung (4/16/2008)

---

FYI, it is ALWAYS possible to construct a mathematical expression that will fit ANY finite set of numbers. for instance:

 WHERE (month(dob)-2) * (month(dob)-6) * (month(dob)-7) * (month(dob)-8) * (month(dob)-11) * (month(dob)-12) = 0

Works just as well.

Norma Jean Claeys (4/21/2008)

---

select * from stud_mast
join (select 2 choice union select 6 union select 7
union select 8 union select 11 union select 12) choices
where month(dob) = choice