Using comparison operators in SELECT clause of T-SQL query

You should use CASE clause:

CASE
    WHEN FieldA > FieldB THEN 1
    ELSE 0
END AS [BIT]