Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: LIKE OPERATOR
On Fri, 2 Jul 2004 17:14:33 +0500, "Oracle Newbie"
<f93c0532_at_yahoo.com> wrote:
>In SQL Server I could write a condition e.g. Name Like '[ABC]%' to bring
>all names beginning with A or B or C. I see that this does not work with
>Oracle. So whats the equivalent?
>
>thx
>
The equivalent is to upgrade to 10g, where you have full regular expressions in SQL and PL/SQL
-- Sybrand Bakker, Senior Oracle DBAReceived on Fri Jul 02 2004 - 13:14:13 CDT