SQLServer Access
CASE...WHEN... IIF()
SUBSTRING() MID()
ISNULL() IIF(IS NULL)
SELECT *,IIf([State]=1,‘√‘,‘ב) as StateTag FROM Leave order by id desc
SELECT IIf([CateID] = 1, "文档"),IIf([CateID] = 2, "视频"),IIf([CateID] = 3, "音频") FROM FileSQLServer与Access常用SQL函数区别
原文：http://www.jb51.net/article/18863.htm
