SQL Server: CASE WHEN OR THEN ELSE END => the OR is not ... It more closely fits the OP's question, and if you want to nest some ...
stackoverflow.com