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: SQL statement using 'IN' clause

Re: SQL statement using 'IN' clause

From: <jhy_at_earthling.net>
Date: 6 Oct 1998 17:00:35 GMT
Message-ID: <361A4CB0.46D7BF2C@earthling.net>


How about:

select * from contact where SUBSTR(postcode,1,2) in ('OX', 'LI');

R Fray wrote:

> Hi,
>
> How can I include a wild card match when using the 'IN' clause? Ie, I
> am wanting to pull out a list of addresses depending on the postcode.
>
> select * from contact where postcode in ('OX6 3NZ', 'OX6 3AZ', etc..)
>
> would work, but what I want to do is :
>
> select * from contact where postcode in ( like 'OX6%', like 'L1%',
> etc..)
>
> Ie, so I can pull out a lot of postcodes without having to define them
> all specifically. Is it possible to combine 'IN' and 'LIKE'? Or do I
> have to use 750 'where' clauses :)
>
> Please cc replies to 'russ_at_u-net.net'
>
> Thanks in anticipation,
> Russell.
>
> --
>
> Russell Fray
> U-NET Ltd.
Received on Tue Oct 06 1998 - 12:00:35 CDT

Original text of this message

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