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?