各位asp高手，我有高分想请教

[fanhongyanfhy]

set rec=server.createobject("ADODB.RECORDSET")
sql="select * from bumen where bumen_bianhao like '" & aa & "%'"
rec.open sql,"database=Binfo;uid=sa;dsn=Binfo;",3
我想从表bumen中找出bumen_bianhao为aa开始的字符串的记录集，但是数据库只能找到
aa的，找不出其他的。请赐教

[cjlong]

写select * from bumen where bumen_bianhao like '" & aa &"'%"

[fanhongyanfhy]

我试了，但是报错。

[hydnoahark]

select * from bumen where bumen_bianhao like '" & aa &"%'"

[xhenry]

如果aa就是字符串
sql="select * from bumen where bumen_biaohao like 'aa%'"
如果aa是存放字符串的变量
sql="select * from bumen where bumen_biaohao like '" & aa & "%'"