Re: select blabla where xy = null (8i)

From: Peter Jenny <peter.jenny_at_cedes.com>
Date: Thu, 9 Aug 2001 08:07:33 +0200
Message-ID: <9kt9b6$bl7$1@rex.ip-plus.net>

Hi Sybrand, hi Brian

thank you very much for your help.

Sometimes also "small hints" are very usefull.

Peter
"Peter Jenny" <peter.jenny_at_cedes.com> schrieb im Newsbeitrag news:9kro2t$81c$1_at_rex.ip-plus.net...
> Hello
>
> why is this sql-statement not working ?
> select count(*) from anlage where pr_Anleitung = null
> I know I've got entries with null, but the result is: 0
>
> And why does
> select count(*) from anlage where pr_Anleitung <> 'Y'
> not select the entries with pr_Anleitung = null ?
>
> Thanks Peter
>
>
Received on Thu Aug 09 2001 - 01:07:33 CDT