Re: SQL statement using 'IN' clause

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