title: Using an Alias column in the where clause in ms-sql 2000
body: <p>I know you cannot use a alias column in the where clause for T-SQL; however, has Microsoft provided some kind of workaround for this?</p>
  
  <blockquote>
    <p><strong>Related Questions:</strong>  </p>
    
    <ul>
    <li><a href="https://stackoverflow.com/questions/200200/can-you-use-an-alias-in-the-where-clause-in-mysql">Unknown Column In Where Clause</a>   </li>
    <li><a href="https://stackoverflow.com/questions/153598/unknown-column-in-where-clause">Can you use an alias in the WHERE clause in mysql?</a>  </li>
    <li><a href="https://stackoverflow.com/questions/46354/invalid-column-name-error-on-sql-statement-from-openquery-results">“Invalid column name” error on SQL statement from OpenQuery results</a></li>
    </ul>
  </blockquote>