Bit values conversion

Hey FabricUser_5037   ... sharing 4 options  😉 without case, I would go for option 2 if your columns is nullable, it's simple and compact 😁🤞 

create table demo2 (
value_col BIT NOT NULL 
); 
insert into demo2 (value_col) values (0); 
insert into demo2 (value_col) values (1); 
select * from demo2

--Option 1: IIF 
SELECT
    IIF(value_col = 1, 'TRUE', 'FALSE') AS MyBitAsText
FROM dbo.demo2;

--Option 2: CONVERT + NULLIF if you have nullable BIT
SELECT
    COALESCE(IIF(value_col = 1, 'TRUE', 'FALSE'), NULL) AS MyBitAsText
FROM dbo.demo2;

--Option 3: CHOOSE 
SELECT
    CHOOSE(CAST(value_col AS int) + 1, 'FALSE', 'TRUE') AS MyBitAsText
FROM dbo.demo2;

--Option 4: Double REPLACE on a cast
SELECT
    REPLACE(REPLACE(CAST(value_col AS varchar(1)), '1', 'TRUE'), '0', 'FALSE') AS MyBitAsText
FROM dbo.demo2;

Hope this solve your request, if so, please accept this as solution and give us a kudos if you find this useful. 

All the very best! Cheers.