Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: LIKE OPERATOR

Re: LIKE OPERATOR

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Fri, 02 Jul 2004 21:12:05 -0700
Message-ID: <1088827958.593800@yasure>


Oracle Newbie 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

As Bagieta has told you the equivalent is to leave off the square brackets.

But there are a few things you need to learn very quickly ...

http://tahiti.oracle.com
http://www.psoug.org/reference/library.html
http://asktom.oracle.com
http://otn.oracle.com
http://docs.oracle.com

With Oracle you will need to RTFineMs. The differences between Oracle and SQL Server are far larger than the similarities. The similarities are superficial.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Fri Jul 02 2004 - 23:12:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US