Tuesday, July 24, 2012

Sql Query - "0" for Inactive "1' for Active

select *, case status when '1' then 'Active' when '0' then 'In-Active' end as Status1 from tblArticleMasterDestination order by Destname

No comments:

Post a Comment