SQL 语句问题（大家来帮帮忙呀）
表a

ID InPutdate
1 null
2 2005-1-1

inputdate 为日期类型

我根据Inputdate这个字段来检索　Inputdate为空的记录呢？


select * from a where inputedate =null
select * from a where inputedate = ' '我都试过了，都不行呢，大家有什么好办法吗？

小弟谢谢啦


[解决办法]
try select * from a where inputedate is null
[解决办法]
select * from a where inputedate is null
[解决办法]
inputedate is null
[解决办法]
is null
is not null