I have a column status which can have three possible values 0,1 and 2.
I am writing a Stored procedure and I'm fetching the values from this column and writing into a new column called progstatus using a case statement.
The condition is when it is 1 it should show active and when 0 then inactive.
however, the records with status 2 should not be fetched.
Now I have written a condition such as
Case [Status] when 0 then 'InActive' when 1 then 'Active' End as ProgStatus,
However records with status 2 is getting value "NULL".. please help modify the case statement.