Kaif 3amal Case when fe Select statement

low 7ad ye2dar yesa3edny ana me7tag 2a3raf el mawdo3 dah darory 2ezai 2a3mal function Case when ely fe el SQL serever fe el access

EX:

fe el SQL serever

Select case when employee_active ='true' then 'Employee is Active' else 'Employee Not Active' end from Table