How to combine multiple columns values into one column value?

Question

I have few columns which has values either 1 or 0. Final result i have to store in one column(F), Which should perform OR operation.

Answer 1

select case when a1 + a2 + a3 > 0 then 1
       else 0 end as F from table1

  

Answer 2

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