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?

Accepted Answer

Try this.

```
SELECT (CASE WHEN LEN(SomeLongTextColumn) = 0 THEN 1 ELSE 0 END) AS IsEmtpy
```

@gbn has good explanation about how to return boolean.

Solution