一个SQL语句有错误，请帮忙看看。：）

[ByronLiu]

这是一个ADO＋ACCESS中用到的。
想在NoteTree表中找 NoteType 等于2 的值。

我写的这句有错误，哪错了，请各位帮改一下！

CString S1="SELECT * FROM NoteTree where NoteType ="+2" ";

谢谢～

[numen27]

"SELECT * FROM NoteTree where NoteType = 2";如果NoteType是整型

[ByronLiu]

如果 2是个int变量该怎么写呢？

[ByronLiu]

没人知道？

[mbj]

CString S1="SELECT * FROM NoteTree where NoteType ='+2' ";
改成单引号

[ByronLiu]

这个我知道了,谢谢了!
各位老大,我还想知道一下,如果这个2是int的变量，那该怎么写？

[surfl]

CString strSQL = _T("");

strSQL.Format("SELECT * FROM NoteTree where NoteType = %d",nUserVar);

....

[arvid_gs]

S1="SELECT * FROM NoteTree where NoteType ='+2' ";

[tanyaliji]

CString S1="SELECT * FROM NoteTree where NoteType ='+2' ";

[xsc2001]

若字段类型为数值则
CString S1="SELECT * FROM NoteTree where NoteType =2";
若字段类型为字符串型
CString S1="SELECT * FROM NoteTree where NoteType =‘2‘";
或
CString S1="SELECT * FROM NoteTree where NoteType like '2'";