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
amarnath reddy ambatiPosted Sep 16, 2014, 10:45 AM
Nitesh KejriwalPosted Sep 14, 2014, 10:41 PM
SELECT id, Ename, Desig, CASE
WHEN Status= '0' THEN 'Not Available'
WHEN Status= '1' THEN 'Available'
WHEN Status= '2' THEN 'Working'
END AS Status
FROM tablename