Re: '' IS NULL?

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Mon, 11 Dec 2000 13:40:08 GMT
Message-ID: <3a34d921.1775083046@news.alt.net>

On Mon, 11 Dec 2000 08:17:57 +0100, "R. Dickhout" <Reinier_Dickhout_at_hetnet.nl> wrote:

>
>> >The options are:
>> >' ' a space
>> >'' a zero-length string
>> >(nothing) NULL
>> >
>>
>> ->SELECT * FROM Dual WHERE '' IS NULL;
>>
>> D
>> -
>> X
>>
>> It would seem that they are the same thing.
>>
>> Brian.
>
>They ARE the same thing. Oracle explicitly states that '' is NULL.
>
>Reinier.
>

Hmm.. Missed that then. I'll keep an eye out for that in the docs. Thanx.

Brian Received on Mon Dec 11 2000 - 07:40:08 CST