Función Case en SQL

CASE WHEN {cond1} THEN {Value1}

     WHEN {cond2} THEN {Value2}

     [ELSE Value n ] END