Column Data Conversion when calling Select Statement

Sep 14 2014 4:15 PM
Dear All,
 
Can you help me below task:
 
I have a table with Ename nvarchar(50), Desig nvarchar(50),Status nvarchar(50)
 
Table Data is:
 id    Ename      Desig        Status
1       Amar      Admin             0 
 
2      Sai           TL                      1
 
3     Vishal     PM                      0 
 
 When calling with Select Statement Status Column I want to show shows 0 is Not Available 1 is Available 2 Working
 
Please Help Me 
  
 
 

Answers (2)