Query leaving out specific data

[aw23]

I just have a quick question on sql syntax. I'd like to select * from table where source="home" and date=#1/26/2005#

except for several id's 1,2,3,4 (except that they are not consecutive and not in the begining or end)

Is there some sort of 'except' clause?
Thanks!

 

[PHV]

SELECT *
FROM yourTable
WHERE source='home' AND [date]=#1/26/2005#
AND ID NOT In (1,2,3,4)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244