Well considering that you are searching for the text 'NULL' and not a null
value
haveyou tried " level2 is null" ?
:-)
- Original Message -
From: "Ward, Mark" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, December 06, 2001 6:37 PM
Subject: NULL Strings
> I don't know
SELECT * FROM classification
WHERE level1 = "FOO" AND level2 IS NULL;
IS NULL instead of = "NULL"
null is not a value, it's the abscence of value
Etienne
"Ward, Mark" wrote:
>
> I don't know how this affects anything, but, I'm running the most recent
> version of mySQL for win98.
>
> Why is
