It is the ~ operator. The SQL Server NOT is used in SQL like "WHERE field NOT IN (list)"
----- Original Message ----- From: "Gyrus" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, December 01, 2001 2:53 PM Subject: NOT and ~ operators > I'm used to using the NOT operator in SQL when using > an Access DB, e.g. > > UPDATE table > SET booleanField = NOT booleanField > WHERE ID = #ID# > > to flip a boolean. > > But in SQL Server, there's 'NOT' and '~' (the "bitwise" > operator). What's the difference? Which is the equivalent > of Jet SQL 'NOT'? > > - Gyrus > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
