1 Nikhil T 2 Amit F
1 Nikhil True 2 Amit False
isnull(colname,"0")
select isequal(colname,'T','True'),isequal(colname,'F','False')
select id,name,case ColumnName when 'T' then 'True' when 'F' then 'False' end as [Status] from ##temp1
select id,name,case when status='T' then 'True' when status='F' then 'False' end from ##temp1
SELECT *, Iif(btype = 't', 'True', 'False') AS res FROM test;
SELECT *, CASE btype WHEN 't' THEN 'True' ELSE 'False' END AS res FROM test;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)