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

Home -> Community -> Usenet -> c.d.o.server -> Re: pattern matching query

Re: pattern matching query

From: Jason Selby <jselby_at_cams.co.uk>
Date: Wed, 03 Jun 1998 17:16:36 +0100
Message-ID: <357576E4.4F82697B@cams.co.uk>


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

ORACLE version------------------

SELECT * FROM table
WHERE substr(field,1,1) BETWEEN 'A' AND 'G'

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

ORACLE version



SELECT * FROM table
WHERE field LIKE 'A%'
AND substr(field,2,1) IN ('A','B','G','H','I')

HTH Jason Received on Wed Jun 03 1998 - 11:16:36 CDT

Original text of this message

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