Condition in Select statement….. T SQL
===

I have a table1 with columns as C1, C2, C3 and C4

All these columns stores bit value(true or false). 

How to write a select query which uses the logical operations on these columns and gets me the final result?

Ex. Select ((C1 OR C2) AND (C3 OR C4)) AS FinalResult  from table1

SQL Server 2008 TSQL
