How to query an empty field?

Hi!

I wrote a query that uses a empty field in the where clause, but it doesn't deliver the expected result.

SELECT count(1) FROM mytable WHERE testfield1 = 2 and testfield2 = NULL;

testfield2 is a NUMBER(15);

Thanks
Tom Received on Sat Nov 15 2003 - 05:13:43 CST