Re: Question

Mike Mascari <mascarm@mascari.com> writes:

> Gaetano Mendola wrote:
>
> > vhikida@inreach.com wrote:
> >
> >> If you are experienced in Oracle, this might be confusing since Oracle
> >> treats empty string and NULL as being the same.
> >
> >
> > Really? I don't believe it.
>
> It is insane, but true.

Uh, yeah, but I think that results in the same behaviour for the case at hand.

ie on oracle this is still holds:

 NULL LIKE '%foo%' => NULL

The idiocy is that Oracle does this:

 '' LIKE '%foo%' => NULL

because it treats '' as if you had NULL, ie, equivalent to the example above.

--
greg