(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