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: Georg Verweyen <georg.verweyen_at_t-mobil.de>
Date: Fri, 25 Sep 1998 13:51:04 +0200
Message-ID: <360B83A8.2B3C@t-mobil.de>


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.

Create a table postcode_tbl with all postcode and try:   select *
    from contact
   where postcode in (select postcode

                        from postcode_tbl 
                       where postcode like'OX6%'
                          or postcode like 'L1%'
                     );

  etc..)

Sincereley Georg V.
Disclaimer: The opinions expressed here are my own and not of the cmpany I am working for. Received on Fri Sep 25 1998 - 06:51:04 CDT

Original text of this message

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