LIKE function

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 - 19:09:53 CET