Re: LIKE function
Date: Wed, 13 Feb 2002 00:28:45 GMT
Message-ID: <1ria8.44198$Pz4.250855_at_rwcrnsc53>
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 - 01:28:45 CET