sql server – How to combine multiple columns values into one column value?

These are known as bitwise operators & described in the MS documentation.
By the sound of it the one you want is a pipe |

create table #t (cola bit,colb bit, colc bit) 

insert #t values(1,0,1)
insert #t values(1,1,0)
insert #t values(0,0,0)

select cola|colb|colc from #t

https://docs.microsoft.com/en-us/sql/t-sql/language-elements/bitwise-operators-transact-sql?view=sql-server-ver15