CASE when Null 问题

[Lion_wen666]

select CASE infotime when Null then '2009-10-10' end from info,结果全都是NUll，请问如何解决

[liangCK]

select case when infotime is null then '2009-10-10' end from info

[liangCK]

select isnull(infotime,'2009-10-10') infotime from info

[liangCK]

select coalesce(infotime,'2009-10-10') infotime from info

[wzy_love_sly]

select CASE when infotime is Null then '2009-10-10' else infotime end from info

[wzy_love_sly]

[Quote=引用 2 楼 liangCK 的回复:]
SQL codeselectisnull(infotime,'2009-10-10') infotimefrominfo
[/Quote]

[pengxuan]

select isnull(infotime,'2009-10-10') as infotime from info