case

SELECT  vBom_ID, vPROJECT_ID,iVERSION,vBOM_VERSION, vPROJECT_NAME,MANUFACTURE_QTY,vSUBMIT_BY, vCHECK_BY,
case when cIS_DONE='y' then '是'
     when cIS_DONE='n' then '否'
end as cIS_DONE ,vDESCRIPTION FROM bombase where cIS_DONE='n' order by vDESCRIPTION desc