select语句中instr怎么写啊?
Tanyz 2014-12-14 03:41:00 表:all 字段:name ,
搜索字段中第一个字符含有left(1,"xx")的记录,怎么写?access+asp的,我写成:
set rs=server.CreateObject("adodb.recordset")
strsql="select * from all where "&instr(1,"name",left(1,"xx"))<>0
rs.open strsql,conn,1,3
出错了!