SQL WHERE statement

[Purecaster]

I need an SQL WHERE statement that gets all records where Year >= 2001 AND NOT records where (Year = 2003 AND Month = 2). I can not figure out how to write this!...and it seems simple enough!!

I've tried WHERE Year >= 2001 AND (Year <> 2003 AND Month <> 2) but it always wants to remove the groupings and give me no 2003 records and no month 2 data. I've also tried AND NOT but that seems to be losing the groupings as well.

Any ideas are appreciated on this one.

Thanks!

 

[sfvb]

Try either:
WHERE Year >= 2001 AND (Year <> 2003 OR Month = 2)
or
WHERE Year >= 2001 AND NOT (Year = 2003 AND Month = 2)

 

[sfvb]

Oops. I has a typo. It should be
WHERE Year >= 2001 AND (Year <> 2003 OR Month <> 2)
or
WHERE Year >= 2001 AND NOT (Year = 2003 AND Month = 2)