select from a list where not in a table

All,

I am trying to select from a list of ids where the ids are not in a table. So far all I've come up with is adding all the ids to a temporary table and then selecting from one where not in the other.

Is there an easy (no table creation) way to do this?

eg. (in pseudo code)

Table Test
id varchar (2)
{'aa', 'cc', 'dd')

List testList
('aa', 'bb')

I want to be able to see 'bb' is in list testList but not in table Test.

appreciate any help
-dmclaude Received on Mon Dec 13 2004 - 11:53:27 CST