On Fri, Jul 29, 2011 at 11:50 AM, Scott Morgan <blumf@...>wrote:

>
> > >
> > > Been wondering why the LIKE statement uses '%' as the wildcard
> character
> > > rather than more common '*' (familiar in file globbing and regex). A
> bit
> > > of googling doesn't turn up much.
>

I think it came from the Oracle implementation from the mid-seventies...

>
> Yes, but why is it the like that in the standard? Somebody must have
> made the decision.
>

Oracle's syntax had a heavy influence on the first standard (1986).

Best regards,

Ann


[Non-text portions of this message have been removed]