How do I return a boolean value from a query during condition evaluation?

Question

I need something like this:

select (len(someLongTextColumn)=0) as isEmpty;

The above doesn't work,

any alternatives?

user_3780749 · Answer

SQL Server:

SELECT CONVERT(BIT, 1) -- true
SELECT CONVERT(BIT, 0) -- false