SQL 代替值问题，求大神解救

Question

求大神解救，把性别中的1，变成女，2变成男，怎么实现，求对应SQL语句；
现SQL语句如下：
select a.cno as 员工编号,a.cname as 姓名, a.sexno as 性别,b.deptname as 部门,a.cdt as 入职日期,c.cbdt as 合同签订日期,c.cedt as 合同结束日期 from hr_epm_main as a
left join dept as b on a.dept=b.deptno
left join hr_epm_cont as c on c.secondside=a.cno
where a.empstatus='01'and a.cname not like '系统%'

现查询结果如下：

Answer 1

 select a.cno as 员工编号,a.cname as 姓名,_ CASE a.sexno WHEN 1 THEN '女' ELSE '男' END as 性别,_b.deptname as 部门,a.cdt as 入职日期,c.cbdt as 合同签订日期,c.cedt as 合同结束日期 from hr_epm_main as a
left join dept as b on a.dept=b.deptno
left join hr_epm_cont as c on c.secondside=a.cno
where a.empstatus='01'and a.cname not like '系统%'