读书人

ACCESS中使用Like的怪有关问题,狂郁闷

发布时间: 2012-03-05 11:54:02 作者: rapoo

ACCESS中使用Like的怪问题,狂郁闷?
ssql= "select * from products where " & field & " like ' * " & value & " * ' " 就算value的值与相应的一样也是返回零行;
换成
ssql= "select * from products where " & field & " = ' " & value & " ' " 什么毛病都没有...
请问问题出在哪里?

[解决办法]
ssql= "select * from products where " & field & " like '% " & value & "% ' "
[解决办法]
ssql= "select * from products where " & field & " like '% " & value & "% ' "

[解决办法]
2楼正解

读书人网 >ASP

热点推荐