On 2/7/07, Björn Reimer <bjoern.reimer@...-erlangen.de> wrote:

> SELECT * FROM PERSONS WHERE "Name" IS NULL;

> record Id=1 is returned.


> SELECT * FROM PERSONS WHERE "Name" = NULL;

> no record is returned but also no error message!

> Is this expected or is it a bug?

Is the way that expected that it works because "NULL" is not a value,
it's a STATE.

> I'd expected either also record Id=1 or an error message but not an
> empty result set!

The sentence is valid and no record match with that constraint so no
recordset is returned and no error is trigged.

--
Saludos,
Toño
----
http://agc.com.mx/antoniogc/blog