Re: [Q] Porting SQL to Oracle

"TurkBear" <john.greco_at_dot.state.mn.us> schrieb im Newsbeitrag news:o6leev0cjaf6ajhioss2vr3tiikvkahm4u_at_4ax.com...
>
> Not religious, just the use of English..
> '=' is not the same as 'IS' ...
>
> One tests for equality ( that is, the same value) while the other tests
for existence...
>
> So while NULL cannot be equal to anything, even itself, it can, an often
does, exist - so test for its existance..ergo, IS or
> IS NOT ....
Ah...
got it. It's Shakespeare: to be or not to be, that's the question!

Thanks for clarifying ;-))

Greetings,
Guido Received on Thu Jun 12 2003 - 03:07:12 CDT