select id,eproduct,eremark from product where product like '"&01&"'
页面运行没有结果(为空),在access的查询中执行也没有结果
select id,eproduct,eremark from product where product = '"&hs-01&"'
才行
怎么回事,access不支持模糊查询么?
...全文
238打赏收藏
Access 中不能用模糊查询么?
select id,eproduct,eremark from product where product like '"&01&"' 页面运行没有结果(为空),在access的查询中执行也没有结果 select id,eproduct,eremark from product where product = '"&hs-01&"' 才行 怎么回事,access不支持模糊查询么?
sql="select id,eproduct,eremark from product where product like '"&%skey_temp%&"'"
-------------------------------------------------------------------^
skey_temp是变量