SQL 把m或f，更改为男女

SELECT nvarcharsname,intsage, CASE charSsex  
WHEN 'm' THEN '男'            
ELSE '女'      
END AS sex 
FROM student