select ygbm,ygxm,(select case when ygxb = ‘1‘ then ‘男‘ else ‘女‘ end) as ygxb,ygmz,sfid,zzmm,ygsr,gzsj,byxx,xlmc,zcmc,jnmc,zwmc,lxdh,gzgw,memo from vw_ygb;?
SQL查询-将性别字段（bit型）显示为“男”、“女”
原文：http://www.cnblogs.com/xusy/p/4832384.html
