title: Getting a boolean from a date compare in t-sql select
body: <p>I am wondering if something along the lines of the following is possible in ms-sql (2005)</p>
  <pre><code>SELECT (expiry &lt; getdate()) AS Expired
  FROM MyTable
  WHERE (ID = 1)
  </code></pre>
  <p>I basically want to evaluate the date compare to a boolean, is that possible in the select part of the statement?</p>