ASP中sql语句带变量怎么表示?

[am2000]

sqlstring="Select from table_name where substring(column_name,2)='"&addr&"' and len(column_name)=4"
我想化为:
...substring(column_name,Len(addr))= and Len(column_name)=Len(addr)+2
怎么表示?
sqlstring="Select from table_name where substring(column_name,"&addr&")='"&addr&"' and len(column_name)="&addr&+2"
对吗?

[am2000]

sqlstring="Select from table_name where substring(column_name,"&len(addr)&")='"&addr&"' and len(column_name)="&len(addr)+2
后面不需要"了吗？

[hqcsx]

sqlstring="Select * from table_name where cloumn1='"&Value1&"' and Cloumn2='"&Value2&"' order by ID"

[am2000]

还是sqlstring="Select from table_name where substring(column_name,"&addr&")='"&addr&"' and len(column_name)="&addr+2&"？

[arcow]

正确与否自己一试便知

[tina2elva]

sqlstring="Select from table_name where substring(column_name,"&len(addr)&")='"&addr&"' and len(column_name)="&len(addr)+2

[银狐被占用]

用楼上就可以

[am2000]

多谢了
sqlstring="Select from table_name where substring(column_name,"&len(addr)&")='"&addr&"' and len(column_name)="&len(addr)+2&" order by column_name"
这也是对的吧。