Boolean expression as column value in transact sql

Question

In most RDBMS:es, this work:

select (5 > 3)

and evaluates to true. It doesn't work in MS Transact SQL and the only workaround I've found is to write:

select case when 5 > 3 then 1 else 0 end

Which kind of sucks because it is much more verbose. Is there a better way to write the above kind of checks?

Answer 1

If the problem is arithmetic comparison:

select (5 - 3)

Then at the application level test for < or = or > 0.