（转）SQL语句Select Case和If else

(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