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