关于判断,我哪里错了?

[ilovediannao2002]

select a.user_no,
a.user_name,
a.office_no,
b.office_name,
a.password,
a.user_post,
a.user_post_name,　
a.sex,
sex_name=((case when a.sex = '0' then '男'),
(case when a.sex = '1' then '女')),
from user_info a,office_info b
where a.office_no = b.office_no

[ilovediannao2002]

里面的case when 老是出现语法错误!我该怎么写呢?

[ALong_Yue]

select a.user_no,
a.user_name,
a.office_no,
b.office_name,
a.password,
a.user_post,
a.user_post_name,　
a.sex,
sex_name=(case a.sex when '0' then '男'
when '1' then '女' end),
from user_info a,office_info b
where a.office_no = b.office_no

[ALong_Yue]

select a.user_no,
a.user_name,
a.office_no,
b.office_name,
a.password,
a.user_post,
a.user_post_name,　
a.sex,
sex_name=(case a.sex when '0' then '男' when '1' then '女' end)
from user_info a,office_info b
where a.office_no = b.office_no

[shalen520]

楼上正解

[wuyq11]

case a.sex when '0' then '男' when '1' then '女' end as sex_name

[fellowcheng]

select a.user_no,
a.user_name,
a.office_no,
b.office_name,
a.password,
a.user_post,
a.user_post_name,　
a.sex,
sex_name=(case a.sex when '0' then '男' when '1' then '女' end)
from user_info a,office_info b
where a.office_no = b.office_no

[feiyun0112]

case a.sex when '0' then '男' when '1' then '女' else '' end as sex_name

[webwait]

同上
1个case就行了

[johnny1983]

来晚了

[活靶子哥哥]

end没有了

[IFocusYou]

end 呢？