VB数据库文本检索。。。。。COME ＯＮ。。。

[joo]

Public cn As New ADODB.Connection
Public rs As New ADODB.Recordset
Public cmd As New ADODB.Command
cn.ConnectionString = "uid=admin;pwd=;driver={microsoft access driver (*.mdb)};dbq=c:\joo\vb\temp\db\total.mdb"
cn.Open
cmd.CommandText = "SELECT * FROM tbl_1 WHERE CONTAINS( jz_no, '" & grid3_key1 & "' )"
cmd.ActiveConnection = cn
rs.Open cmd
如：我给 grid3_key1 赋值 1-3
但是编译是提示的错误信息是：
[microsoft][ODBC microsoft access driver] syntax error(missing operator)
in query expression CONTAINS(jz_no,'1-3').
请问 cmd.CommandText 那里有错。。。？ CONTAINS（）怎么用。。？？

[natfit]

cmd.CommandText = "SELECT * FROM tbl_1 WHERE jz_no like '*" & grid3_key1 & "*' )"

[redcoral]

cmd.CommandText = "SELECT * FROM tbl_1 WHERE jz_no like '*" & grid3_key1 & "*'" 应该是

[zhhrlzm]

cmd.CommandText = "SELECT * FROM tbl_1 WHERE jz_no like '%" & grid3_key1 & "%' )"

[joo]

tbl_1表的jz_no字段是text类型。。。
用了。。cmd.CommandText = "SELECT * FROM tbl_1 WHERE jz_no like '*" & grid3_key1 & "*'" 或
cmd.CommandText = "SELECT * FROM tbl_1 WHERE jz_no like '%" & grid3_key1 & "%'"
还是不能找到为什么？

[natfit]

现在是什么错误？

[joo]

谢谢 natfit 已经搞定。。