Re: LIKE function

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 Tue Feb 05 2002 - 20:56:09 CET