Question

sql语句where两个条件都是变量怎么写

asp+access
sql="select * from fwzq where text like '%"&tbKey&"%'"
like 模糊查询条件是变量，还想加个条件 num=num1 num1是变量
num1是从列表菜单获取的值

Answer 1

如果num是字符型，使用下面语句：
sql="select * from fwzq where text like '%"&tbKey&"%' and num='"&num1&"'"
整型使用下面语句
sql="select * from fwzq where text like '%"&tbKey&"%' and num="&num1&""

Answer 2

加个 "and" 就行啦

sql="select * from fwzq where text like '%"&tbKey&"%' and num = num1 "

Answer 3

不论num是什么类型，都用下面这个
sql="select * from fwzq where text like '%"&tbKey&"%' and num like '"&num1&"'";

Answer 4

sql="select * from fwzq where text like '%"&tbKey&"%' and num="&num1