How to Use OR in the ELSE part of the CASE statement

HardRumma

New Member
Here is my requirement.. in the sql CASE statement when the WHEN condition is met THEN part is to be executed.. if the condition is not met then I need to have two options to select from (meaning that I need to have an OR in the ELSE part)..I am stuck here..\[code\]CASE WHEN tablename.ID=0 THEN tablename.description ELSE tablename.description2 OR tablename.description2 END AS abcd\[/code\]I'm doing a foxpro to sql migration, so encountered a statement in foxpro which uses '/' in the ELSE part of its CASE(called IIF in foxpro) statement..I am assuming '/' to be OR in SQLAny solution to meet this requirement please?
 
Back
Top