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楼正解