help with replacing OR in query

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 - 02:26:26 CEST