john.arnott (4/16/2008)
rbarryyoung, I don't quite follow your code, there. Somethng missing?
That was just the Where clause. Here is the whole query:
Select *
From stud_mast
WHERE ( month(dob)-2)
* (month(dob)-6)
* (month(dob)-7)
* (month(dob)-8)
* (month(dob)-11)
* (month(dob)-12) ) = 0
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]