SQL Exists Query

SELECT CASE WHEN EXISTS (<SELECT STATEMENT>)
THEN CAST(1 AS BIT)
ELSE CAST(0 as BIT)
END as [exists];