Question

asp+access 做模糊查询

txt = Request.QueryString("txt")
sqlStr = "select * from News where NewsTitle like "

"select * from News where NewsTitle like " 怎么加 txt

Answer 1

select * from 表名 where 字段 like txt

Answer 2

sqlStr = "select * from News where NewsTitle like '%"&txt&"%'"

Answer 3

sqlStr="select * from News where NewsTitle like '%"&Request("txt")&"%'"

Answer 4

"select * from News where NewsTitle like '%"&txt&"%"