Re: '' IS NULL?

> >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. Received on Mon Dec 11 2000 - 01:17:57 CST