Excluding many values in a column don't want to use a bunch of where and's

[danaleota]

Hi,

I would like to load a table that has a column - Years and there are many values of years I don't want to include.  Instead of writing:

Where Year <>  1800 And Year <> 1801 And Year <> 1802 And Year <> 1803 

Is there a faster way to write this out in a statement?  Thank you.  

[sunny_talwar · Accepted solution]

You can do this

Where Year >= 1804;

or

Where not Match(Year, 1800, 1801, 1802, 1803,...);

[danaleota]

Ah thank you!