title: SELECT COL1+COL2 as CalcColumn,* FROM TABLE WITH (NOLOCK) WHERE 100<COL1+COL2
body: <p>In a SELECT statement using a condition based on a calculated value, is it possible to include that calculated value without computing the calculated value twice - once in the selection and again in the condition?</p>
  
  <p>I am using SQL Server 2000.</p>