Re: LIKE OPERATOR

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)