SQL 把m或f,更改为男女

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

 

posted @ 2014-01-12 15:27  JasonGu0  阅读(800)  评论(0编辑  收藏  举报