SQL SERVER 2012:
SELECT CAST(IIF ( field = 1, 1, 0 ) AS BIT) FROM table
Otherwise:
SELECT CAST(CASE field WHEN 1 THEN 1 ELSE 0 END AS BIT) From table
SQL SERVER 2012:
SELECT CAST(IIF ( field = 1, 1, 0 ) AS BIT) FROM table
Otherwise:
SELECT CAST(CASE field WHEN 1 THEN 1 ELSE 0 END AS BIT) From table