Re: LIKE function

nice dig (double-entendre intended).

;-D

Ken Papai wrote:
>
> Here is the answer:
>
> http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.
> 817/a85397/expressi.htm#1029459
>
> ; -)
>
> "Bricklen" <bricklen_at_shaw.ca> wrote in message
> news:3C60388D.1A54CFC_at_shaw.ca...
> > hmmm... why, yes there is.
> >
> > (sorry if I seem a bit snarky. that question shows that you did zero
> > searching for the answer anywhere else).
> >
> >
> > cheers,
> > Bricklen
> >
> >
> > Nick69 wrote:
> > >
> > > Hello All.
> > > A short question. Is there in the Oracle something like MS SQL has
> > > LIKE operator? I mean operator LIKE. See exapmle below, please.
> > >
> > > In MS SQL:
> > > SELECT au_lname, au_fname, phone
> > > FROM authors
> > > WHERE au_fname LIKE '[CS]heryl'
> > > ORDER BY au_lname ASC, au_fname ASC
> > >
> > > or
> > >
> > > WHERE au_fname LIKE '[A-Z][A-Z][A-Z][0-9][0-9]'
> > >
> > > Thank in advance.
Received on Wed Feb 13 2002 - 02:19:28 CET