pattern matching query

From: <hyseo_at_samsung.co.kr>
Date: Wed, 03 Jun 1998 03:20:11 GMT
Message-ID: <6l2fdb$paq$1@nnrp1.dejanews.com>

Dear Oracle Professionals.

Hi I'm a new user of ORACLE.

I came from Sybase DB server experience.

In Sybase I used select statement like belows.
==> select * from table where field like '[A-G]%'

select * from table where field like 'A[ABGHI]%'

In ORACLE SQL this expression is not recognized I have read the Oracle SQL manual but I have not found the solution

HELP me

Thanks

HaengYong

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Jun 02 1998 - 22:20:11 CDT