vb的Dao用*作匹配符
如:
dim db as database
dim rs as dao.recordset
set db=opendatabase("库.mdb")
set rs=db.openrecordset("SELECT * FROM 客户信息 WHERE 电话 like '*016' ",dbopendynaset)
而Ado用%作匹配符
dim conn as adodb.connection
dim rs as ado.recordset
set conn=new connection
conn.open "ODBC数据源名"
set rs =new recordset
rs.open "SELECT * FROM 客户信息 WHERE 电话 like('%016') ",conn,2,3