Hi . I think I have found a bug with the operator = and <> and NULL values.
I have this table : CREATE TABLE ( ID INT NOT NULL, Text VARCHAR(15), PRIMARY KEY (ID) ) and theses values : INSERT INTO Test VALUES (1, 'Laurent'); INSERT INTO Test VALUES (2, NULL); When I run this query : SELECT * FROM Test WHERE Text = NULL; I got 0 rows but if I run this query : SELECT * FROM Test WHERE Test IS NULL I got 1 row. (Same for <> NULL and IS NOT NULL). Is it a bug or not ? If not, should the user be warned that he can't use the operator = or <> with NULL . Laurent _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
