摘要： (case FieldName When 0 then 1 when Null then 1 else FieldName end) as FieldNamehttp://www.cnblogs.com/sekihin/archive/2007/04/20/721252.html 阅读全文