not null -> true and null -> false

select 
CASE
 when ImageFile is NULL then 0
 else 1
end as HasImage
from News