求一个查询的语句！急。。。在线等.......

[goodfeng110]

一个表test中其中一个字段a类型为smalldatetime,值如
2004-4-20
2003-4-20
想通过输入4-20模糊查询查出所有包含4-20的
我这样写查不了！
select * from test where a like '4-20';
请问要怎么写才可以

[pbsql]

select * from test where convert(varchar(4),a,101)='04-20'

[tangxiaosan001]

你可以用select * from test where a like '%4-20'

[pbsql]

select * from test where convert(varchar(5),a,101)='04/20'

[pbsql]

才发现楼主也用此名，有版权的哦:D

[jackiezhang]

select * from test where substring(cast(aa as varchar(20)),1,5)='04 20'