Odpowiednik decode w MS SQL

SELECT CASE when t.TS_EXEC_STATUS='Failed' THEN 8 else 1 END AS magia
FROM test t