数据库查询出有关问题_Sql Server

数据库查询出问题
select distinct 物料名称= FItemID,金额=sum(FAmount) from vwICBill_1 where FDate like '2009-01%' group by FItemId

语句正确执行但是没有结果是在+入like‘2009-01’后出的错，请指点、、、、、

------解决方案--------------------

SQL code

select distinct 物料名称= FItemID,金额=sum(FAmount) from vwICBill_1 convert（varchar(10),FDate,120)  like '2009-01%' group by FItemIdtry
------解决方案--------------------
select distinct 物料名称= FItemID,金额=sum(FAmount) from vwICBill_1 where FDate like '[2009-01]%' group by FItemId

试试
------解决方案--------------------
SQL codeselect distinct 物料名称= FItemID,金额=sum(FAmount) from vwICBill_1 where convert(varchar(7),FDate,120)='2009-01' group by FItemId