have you tried just putting NOT IN ?
> From: "Adrian Cesana" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date: Mon, 10 Jul 2000 17:14:11 -0700
> To: <[EMAIL PROTECTED]>
> Subject: SQL
>
> Is there anyway to do the opposite of this...? I need something like NOT IN.
>
> SELECT blah from blah WHERE Blah IN('blah1','blah2','blah3')
>
>
> -Adrian
>
>
>
>
> ------------------------------------------------------------------------------
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in the
> body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
