ACCESS 模糊查询
sql = "select top " + pagesize + " * from (select top " + number + " * from SmallProduct where SmallProductKeyWords like '*" + keywords + "*' order by SID asc) order by SID desc";


这是我写的 查出来的结果不对 ，明明是空的，怎么还能有结果 ，各位帮看看吧

[解决办法]
sql = "select top " + pagesize + " * from (select top " + number + " * from SmallProduct where SmallProductKeyWords like '%" + keywords + "%' order by SID asc) order by SID desc";

*只能用作access里面，程序查询要使用%