Null Value check

Ramco Ramco

3y743SQL

In below condition i wanto check for Null Value also. If Value is Null then also No

case when [OnBreak] = 0 then 'No' else 'Yes' End as [OnBreak],

Thanks

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Accepted answer

case 
    when [OnBreak] = 0 then 'No' 
    when [OnBreak] IS NULL then 'No'
    else 'Yes' 
End as [OnBreak]