Re: Question

Mike Mascari <mascarm(at)mascari(dot)com> writes:

> Gaetano Mendola wrote:
>
> > vhikida(at)inreach(dot)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