[Solved] SQL Statement two columns value return single value [closed]

by


Try this

select id,[date],(case  when refund = 1 then 'R'
                        when voidstatus = 0 then 'C'
                        when  voidstatus = 1 then 'V'
                        else '' end
                ) as [status],grossamt
from    trans

2

solved SQL Statement two columns value return single value [closed]