Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
You can do this
Where Year >= 1804;
or
Where not Match(Year, 1800, 1801, 1802, 1803,...);
You can do this
Where Year >= 1804;
or
Where not Match(Year, 1800, 1801, 1802, 1803,...);
Ah thank you!