【SQL】CASE 條件式用法

語法: Case when 欄位=值1 then 文字1 when 欄位=值2 then 文字2 else null End

Ex:
SELECT T0.[U_EmpID], T0.[firstName],
Case when T0.Sex='F' then '女' when T0.Sex='M' then '男' else null End as N'性別',
Case when T0.martStatus='S' then '未婚' when T0.martStatus='M' then '已婚' else null End as N'婚姻狀態' ,

Case when  T0.dept=-2 then '管理部' when T0.dept = 4 then '業務一部'  when T0.dept=5 then '業務二部' 
          when T0.dept=6 then '資材部' when T0.dept=7 then '研發部' when T0.dept=8 then '工程部' 
          when T0.dept=9 then 'FAE' when T0.dept=11 then '中國業務部' else null End as N'部門', 

Case when  T0.Status=1 then '外調' when T0.Status=2 then '在職' when T0.Status=3 then '離職' 
           when T0.Status=4 then '考核' else null End as N'就職狀態'
FROM OHEM T0
WHERE T0.citizenshp = 'CN'  and T0.Status is not null
ORDER BY T0.U_empID