dummy value?

From: okey <oldyork90_at_yahoo.com>
Date: Tue, 20 Apr 2010 15:07:19 -0700 (PDT)
Message-ID: <cd910ca4-f947-45ce-9e59-6e9544847aa6_at_q23g2000yqd.googlegroups.com>

I have large list I use in an 'IN' clause

select * from mytable where x in { HUGE LIST }

What I want to do is find all the entries in that huge list that do not match. Some how I have to get the list value into a variable. Can that be done?

select var from mytable where var putinvar { HUGE LIST } and var <> field

This has to be easy to do... it just ain't click'n

Thanks for your help. Received on Tue Apr 20 2010 - 17:07:19 CDT