Replace number with word using CASE statement in SQL Server

Last Reply 7 months ago By pandeyism

Posted 7 months ago

i have a query:

 

select emp.name,emp.address,emp1.app_status from Table inner join table1

I am exporting it into excel file. In the database app_status is in the form of 0 and 1.

1 means application received. 0 means application not received.

i am getting the app_status column as in the form of 0 and 1.(while exporting to excel file)

How to make it in words in sql query.

This question does not have replies that have been liked.