Pages

Thursday 21 February 2013

'CASE' in SQL Server


where IsActive =column name
systempostalcode=table name


column IsActive has 1 or 0 values.
we want to return true if IsActive =1, and return false if IsActive =0

select  City, StateCode,  CountryCode, case when IsActive = 1 then 'True' else 'False' end as IsActive   from systempostalcode


No comments:

Post a Comment