关于在asp中sql语句调用变量的问题,请大家帮帮忙

[hulei_2000]

是采用asp+acess

sid= trim(request("id"))
//取id的值并给sid后我想用以下语句查询
sql="select * from 表A where 字段B like sid&'%' order by 字段B

假设sid取后的值为16,我想询字段B(字符型)中包含16的记录,上述语句是否写错了,麻烦大家帮忙修改一下..谢谢...

[subasan]

sql="select * from 表A where 字段B like '%"&sid&"%' order by 字段B

[liangjianshi]

楼上正解

[sxsgssgs]

如果id是字符型的:
sql="select * from 表A where 字段B like '%"&sid&"%' order by 字段B

id为数字型时:
sql="select * from 表A where 字段B like %"&sid&"% order by 字段B