用between andselect * from 表名 where 字段名 between 2009-10-01 00:00:00 and 2009-10-31 23:59:59
SELECT * FROM xiaoshouWHERE time like '2009-8'&'*';access和SqlServer的模糊查询有些不一样。
