Re: help with replacing OR in query

Piece of cake... replace your query with:

select

   col1
from

   table1
where

   col2 = 'xxx'
UNION
select

   col1
from

   table1
where

   col3 = 'xxx'

JP

erick_papadakis_at_yahoo.com (Erick Papadakis) wrote in message news:<737aefee.0208121626.578cf5b6_at_posting.google.com>...
> p.s., if you reply, kindly CC me as well.
>
> hi, i have the following SQL query
>
> select col1 from table1
> where
> col2 = 'xxx' or col3 = 'xxx'
>
> how can i get rid of this OR? due to my table design and the logic
> involved, i have to check both these 2 columns (in a search function). i
> cannot concaneate them to make a third column because i need to check for
> exact match but for both the columns.
>
> so what can i do to replace the OR, because the OR makes the query skip any index.
>
> thanks in advance for any insight/ideas!
>
> .ep
Received on Tue Aug 13 2002 - 16:06:23 CEST