<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>

One workaround would be to use a derived table.
For example:
```
```
select *
from 
   (
   select a + b as aliased_column
   from table
   ) dt
where dt.aliased_column = something.
```
```
I hope this helps.