need help on CASE usage in Where clause

[hnkadmn]

here I am giving only where clause. existing where clause is having so many or conditions, can I replace with Case.
Please suggest.

Where
( a = 1 and b=2) or
(a=3 and b=4) or
(a=4 and b=8)

Can replace with

Where
Case
When ( a = 1 and b=2) then " here what should we do"
When (a=3 and b=4) then "here what should we do"
When (a=4 and b=8) then "here what should we do"
Else null ("is it ok&quot
End is not null


Hari

 

[blom0344]

Hari,

The CASE expression is not used in the where clause but in the select part:

Select
Case
When ( a = 1 and b=2) then " here what should we do"
When (a=3 and b=4) then "here what should we do"
When (a=4 and b=8) then "here what should we do"
Else "is it ok"
End
from..................

T. Blom
Information analyst
tbl@shimano-eu.com

 

[hnkadmn]

Hi Blom

Thanks for your suggestion. I tried executing the SQL, it gave same result as having multiple OR's. But it took more CPU time.

Hari

 

[PruSQLer]

Where did you put the Case Statements - in the Select or the Where clause?