like的问题

[sisiz]

我想从数据库里查找2003-9月份的所有记录，设计的是从表单里选择“2003-9”提交到A.ASP页，在A.ASP页里我写的代码是：打开数据库然后
riqi=Request.Form("riqi")
session("riqi")=riqi
sql="select * from luntan where riqi like 'riqi%'"
但是一个记录也查不到，也没有提示错误！这样写是不是错误！请高手们帮我看看！

[xianglong]

sql="Select * From luntan where riqi like '"&riqi&"%'"

[Primer2002cn]

sql="select * from luntan where riqi like '% " & riqi & "%'"

[coffee_cn]

sql="select * from luntan where DateDiff('d',riqi," & riqi & ")=0"

or

sql="select * from luntan where riqi like '"& riqi & "%'"

[lxqlogo0]

sql="select * from luntan where riqi like '" & riqi & "%'"

[pimple]

sql="select * from luntan where riqi like 'riqi'"

这样即可.

[ttt2]

select * from luntan where month(riqi)=9 and year(riqi)=2003

[dicklee1214]

sql="select * from luntan where riqi like '"&riqi&"%'"

[homeyang]

sql="select * from luntan where riqi like '%" & riqi & "%'"