(case FieldName When 0 then 1 when Null then 1 else FieldName end) as FieldName
http://www.cnblogs.com/sekihin/archive/2007/04/20/721252.html
(case FieldName When 0 then 1 when Null then 1 else FieldName end) as FieldName
http://www.cnblogs.com/sekihin/archive/2007/04/20/721252.html
转载于:https://www.cnblogs.com/OnlyDreams/archive/2012/05/09/2492106.html