sql server中类似oracle中decode功能的函数CASE....WHEN...

在Access中实现 case when功能
在Access无法使用SQL语句中的case when语句，但可以通过Switch函数实现

例如：

Switch(成绩<60,"不及格",成绩 Between 61 And 74,"中",成绩 Between 75 And 88,"良",成绩 Between 88 And 100,"优") AS 成绩等级

可以实现对成绩的值进行多分支条件判断结构

oracle中 select SNAME,Decode(FENSHU,90,'优秀',80,'良好',60,'及格','不及格') from S_STUDENT

SQL SERVER中

select t.PROJECTNAME,
	t.BUILDCONTENTSCALE, 
	CASE t.PROJECTLEVEL
      WHEN '0' THEN '国家重点'
      WHEN '1' THEN '省重点'
      WHEN '2' THEN '市重点'
      WHEN '3' THEN '区/县重点'
      END AS PROJECTLEVEL,
	t.TOTALINVESTMENT,
	t.PROGRESSCONTENT,
	t.BUILDCOMPANY, 
	t.CONTACTWAY,
	t.DUTYDEPT,
	t.REMARK 
from t_iipms_applayprojects t 
	where t.projecttype = '1'  
	and t.isvoided = '0';