数据库查询出有关问题

数据库查询出问题
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 code
select distinct 物料名称= FItemID,金额=sum(FAmount) from vwICBill_1 where convert(varchar(7),FDate,120)='2009-01' group by FItemId