ACCESS µÄÓï¾ä

        string strSQL = "select top 9 wj_ID, if len(wj_CompanyName)>13 then left(wj_CompanyName,13) else wj_CompanyName as wj_CompanyName from wj_User where uFlag=0 and wj_true=1 order by wj_ID desc";


ÕâÑùµÄÓï¾äÕýÈ·Âð£¿

---

ÔÚACCESS£¿
tring strSQL = "select top 9 wj_ID, iIf(len(wj_CompanyName)>13,left(wj_CompanyName,13), wj_CompanyName) as wj_CompanyName from wj_User where uFlag=0 and wj_true=1 order by wj_ID desc";

---

ÕâÑùºÃÏóûÓÃ
ÖÁÉÙÒ»¸ö²ÎÊýûÓб»Ö¸¶¨Öµ
Õâ¸öÊÇÏÔʾ´íÎó
¶÷¡£ÎÒµÄÊÇACCESSµÄ

---

string strSQL = "select top 9 wj_ID, iif(len(wj_CompanyName)>13 ,left(wj_CompanyName,13) ,wj_CompanyName as wj_CompanyName ) from wj_User where uFlag=0 and wj_true=1 order by wj_ID desc";

---

ÔÚACCESSÖÐÖ±½ÓÔËÐУ¬²âÊÔ£¬SQLÓ﷨ûÓÐÎÊÌâ

---

C# code:
string strSQL = "select top 9 wj_ID, iif(len(wj_CompanyName)>13 ,left(wj_CompanyName,13) ,wj_CompanyName) as wj_CompanyName from wj_User where uFlag=0 and wj_true=1 order by wj_ID desc";




À¨ºÅµÄλÖò»¶Ô¸ÄÁËһϡ£

Èç¹û»¹±¨´í£¬½¨ÒéÄãÖ±½ÓÔÚACCESSÖÐÖ´ÐÐÒ»ÏÂÕâ¸öÓï¾äÒÔÅж¨¹ÊÕÏλÖá£

SQL code:
select top 9 wj_ID, iif(len(wj_Compan