Menggunakan IF di sql server

di sql server gak ada if. adanyanya case

select [status],case when [status]=1 then 'active' else 'inactive' end as 'status_text'

from psm_personnel_detail