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