<p>I made a view to abstract columns of different tables and pre-filter and pre-sort them. There is one column whose content I don't care about but I need to know whether the content is null or not. So my view should pass an alias as "<em>true</em>" in case the value of this specified column <strong>isn't null</strong> and "<em>false</em>" in case the value <strong>is null</strong>.</p>

<p>How can I select such a boolean with T-SQL?</p>

You have to use a
CASE
statement for this:
```
```
SELECT CASE WHEN columnName IS NULL THEN 'false' ELSE 'true' END FROM tableName;
```
```