有关查询的问题?SQL语句

[feifei123321]

我想作一个查询，找出表中所有编号小于0的记录我这么写为什么不对呀
sqlu="select * from book where bookid <'"&0&"' order by id desc"

[youbest]

i=0
sqlu="select * from book where bookid <"&Cstr(i)&" order by id desc"

[WUNEN]

sqlu="select * from book where bookid <'0' order by id desc"

[cityroom]

你的编号是什么类型的。如果是字符型的，楼上的没有问题~

如果是整型的可以这样~：sqlu="select * from book where bookid <0 order by id desc"

[leo1999]

你的bookid的数据类型是什么阿？
数字？
sqlu="select * from book where bookid < 0 order by id desc"