This is expected. =NULL will never work as NULL is not a value, it isn't
anything really. - and therefore it cannot be equal to anything.
You always have to use IS NULL.
-Original Message-
From: Will Tomlinson [mailto:[EMAIL PROTECTED]
Sent: 09 February 2006 10:27
To: CF-Talk
Hey Will... I've experienced the same thing and would be curious to know
as well... I've just chalked it up to just being a pure syntax thing...
nothing more than that's just the way it is in SQL server... let's see
if anybody can clarify
Tim
-Original Message-
From: Will Tomlinson
I'm guessing that it is just a syntax thing...somewhere in the SQL
Server engine, it makes it easier for them to handle the comparison.
Oddly, the update isn't like that...when you set a column to NULL, you
use col_name = NULL, not something like col_name TO BE NULL
On the subject, here is a
2006 14:20
To: CF-Talk
Subject: Re: IS NULL VS = NULL
I'm guessing that it is just a syntax thing...somewhere in the SQL
Server engine, it makes it easier for them to handle the comparison.
Oddly, the update isn't like that...when you set a column to NULL, you
use col_name = NULL, not something
Hi,
I'm guessing that it is just a syntax
thing...somewhere in the SQL
Server engine, it makes it easier for them to
handle the comparison.
well, as Neil already said, NULL is not a value and thus can not be compared to
any other value or field content. NULL actually means the field
://acoderslife.com
-Original Message-
From: Jim Wright [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 09, 2006 9:20 AM
To: CF-Talk
Subject: Re: IS NULL VS = NULL
I'm guessing that it is just a syntax thing...somewhere in the SQL
Server engine, it makes it easier for them to handle the comparison
-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 09, 2006 9:43 AM
To: CF-Talk
Subject: RE: IS NULL VS = NULL
Maybe if you SET the filed to the string 'NULL' but NULL has never been
tested by '=' that I've seen. It's not a value. I doubt an update
OK, I guess I stepped on a nerve here...and in retrospect, I should
have thought out my post more
-I should not have made a reference to SQL Server...the IS NULL
operator is part of the ANSI-92 standard, and would be used in any
database that conforms to that(but the original post was
It's proper SQL Willsimple as that. ;-)
The reason is NULL is nothing...and something cannot equal nothingbut it
can
be NULL...so we sqay IS NULL or IS NOT NULL.
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax:
Thanks Bryan! That makes sense. :)
Will
hehe...if you're looking for a non-technical answer...ask meI shy away from
jargon...never know if the other person gets what you're laying down ;-)
Cheers
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group
10 matches
Mail list logo