Re: Query Which is not supposted to list NULLS is listing

On Tue, May 27, 2003 at 02:13:55PM +0530, shreedhar wrote:
> Hello,
>
> I am attaching an output with this mail. I am sure that I am not inserting
> '' for jobcomments in any case.

Please note that '' is not null.  It's an empty string.  Oracle gets
this wrong, so if you're used to the Oracle syntax, that might be
your problem.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110