Re: is it possible 2 use IN(..) instead of c1 like 'a%' or c1 like 'b%'

No. Try UNION or UNION ALL as in:

SELECT *
FROM mytable
WHERE c1 LIKE 'a%'
UNION
SELECT *
FROM mytable
WHERE c1 LIKE 'b%';

Daniel Morgan

Steffen Ramlow wrote:

> c1 in('a%','b%') does not work
>
> any suggestions?
Received on Mon Feb 04 2002 - 14:24:53 CST