如何让显示出来的列的性别变成汉字男女，我图片Sex列的1，0变成男女，然后表格其他信息不变，要怎么做？

Question

create PROCEDURE yd_StudInfo
@class char(10)
as 
Select CASE Sex WHen '1' THEN '男' WHen '0' THEN '女'  end as Sex from StudInfo
select * from  StudInfo where Class=@Class

GO
EXEC  yd_StudInfo @class='应用1001'
GO


![图片说明](https://img-ask.csdn.net/upload/201906/02/1559457594_219062.png)

Answer 1

Select CASE Sex WHen '1' THEN '男' WHen '0' THEN '女'  end as Sex from StudInfo
select * from  StudInfo where Class=@Class

->

Select stuno, name, CASE Sex WHen '1' THEN '男' WHen '0' THEN '女'  end as Sex, idno, mobile, courseno, class from StudInfo where Class=@Class