Using SELECT for simple BOOLEAN evaluation

SELECT
  CASE
    WHEN 2 > 1 THEN 1
    ELSE 0
  END

Edit:

SQL Server 2012 (Denali):

SELECT IIF(2 > 1, 'TRUE', 'FALSE')

SELECT CASE WHEN 2 > 1 THEN 'True' ELSE 'False' END

SELECT CASE WHEN 2 > 1 THEN cast(0 as bit) ELSE cast(1 as bit) END

Related