SELECT ((SELECT COUNT(*) FROM DEPARTMENT WHERE ISN_HIGH_NODE = 3614) > 0) as HasChild, * FROM DEPARTMENT WHERE ISN_NODE = 3614
SELECT CASE when (SELECT COUNT(*) FROM DEPARTMENT WHERE ISN_HIGH_NODE = 3614) > 0 then 1 else 0 end as HasChild, * FROM DEPARTMENT WHERE ISN_NODE = 3614