模糊查询

[18320606]

我的命令语句是：
commandText="select * from TongXunLu where " & x2 & "='" & x3 & "'"
set rs = conn.Execute(commandText)

x2为传递过来的select菜单的值，x3为<input type=text>的值.

请问如何实现模糊查询，顺便给我讲解一下有关filter方面的语法，万分感激。。。

[511214]

commandText="select * from TongXunLu where '" & x2 & "'='%" & x3 & "%'"
set rs = conn.Execute(commandText)

[511214]

应该是这个
commandText="select * from TongXunLu where " & x2 & "like'%" & x3 & "%'"
set rs = conn.Execute(commandText)

[zhanghao5188]

“select * from TongXunLu where 字段 like '%" & x3 & "%' "

[lious]

filed like '% keyword %'

[lvjinyou]

同意
commandText="select * from TongXunLu where " & x2 & "like'%" & x3 & "%'"
set rs = conn.Execute(commandText)