Replace number with word using CASE statement in SQL Server

chetan

SOLVED CLOSED ACTIVE ANSWERED
User: chetan
Posted: on Jun 13, 2019 12:02 AM
Forum: SQL Server
Answer: 1
Views: 2438

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.

Download FREE API for Word, Excel and PDF in ASP.Net

pandeyis...

0 1

Reply
ANSWER
User: pandeyism
Replied: on Jun 13, 2019 12:05 AM
Report

Use case statement.

SELECT emp.name,emp.address,
case when emp1.app_status = 1 then 'application received'  
     when emp1.app_status = 0 then 'not received' end as appstatus 
FROM table emp
inner join table1 emp1 on emp.id = emp1.id

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Replace number with word using CASE statement in SQL Server

Company

Explore

Follow us

Contact Us