title: How to output a boolean in T-SQL based on the content of a column?
body: <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>