[MSSQL]Record it : Mssql familiar instruction >case

Record it : Mssql familiar instruction >case

case (change Value)

use testdb

select

case (E.testcolumn )

when '1' then 'Reject'

when '2' then 'Allow'

when '3' then 'Deny'

else 'No data' end 'status'

from testtable