Re: How to query an empty field?

From: Chris <cs123._no_spam__at_telstra.com>
Date: Sat, 15 Nov 2003 11:26:16 GMT
Message-ID: <s3otb.11915$aT.2121@news-server.bigpond.net.au>

"Tom Miskiewicz" <miskiewicz2_at_yahoo.com> wrote in message news:bp51qf$erq$1_at_news.gatel.net...
> 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
>
>

SELECT count(1) FROM mytable WHERE testfield1 = 2 and testfield2 IS NULL Received on Sat Nov 15 2003 - 05:26:16 CST