Any function to edit the results in SQL?

Question

Hi,

I have a report in SQL. One of the columns has either '0' or '1'. I want to replace all the 0s and 1s by 'Inactive' and 'Active'. Is thereany SQL function that can be used to modify the report ?

Answer 1

try this query



SELECT names,

CASE

WHEN status = '1' THEN 'Active'

WHEN status = '0' THEN 'Inactive'

ELSE '-'

END

FROM students

Answer 2

select case Yourcolumn when 0 then 'Inactive' when 1 then 'Active' end Status

from <...>

Answer 3

update TableName set ColumnName = 'Active' where ColumnName = 1



update TableName set ColumnName = 'Inactive' where ColumnName = 0