title: SQL Server : fire trigger on SELECT? (Calculated Column)
body: <p>I need a column to be dynamic as such that a column <code>DaysToExpiration</code> is calculated based on the number of days between now and a date column <code>Expiration Date</code>. </p>
  
  <p>My plan was to add a trigger that fires on a <code>SELECT</code>statement of the table.</p>
  
  <ol>
  <li>Is this possible? How?</li>
  <li>Is there a better way to go about this? </li>
  </ol>