Depending on which angle you look at it from. I see it as comparison and in that case it the same as x==NULL.
Ilya -----Original Message----- From: PD Miller To: Michael Peppler; Tim Bunce Cc: Sterin, Ilya; '[EMAIL PROTECTED]' Sent: 10/23/01 11:29 AM Subject: Re: = NULL vs. IS NULL At 9:51 -0700 23/10/01, Michael Peppler wrote: >And just to be complete, Sybase (and possibly MS) has an "ansinull" option >that can be set. If it is not set then the "x = null" *will* work correctly. I'm not sure about the use of 'correctly' here. NULL is the absence of value and therefore cannot be equal to anything. 'x = NULL' is the same as 'FALSE'. Regards Paul Miller -- - Carib Data Limited <mailto:[EMAIL PROTECTED]> <http://www.caribdata.co.uk>