title: Use Sql server column alias in where condition
body: <p>I am writing a sql server query with one column as a expression like</p>
  
  <pre><code>Select name , name + age as Test from myTable
  where Test like '%b%';
  </code></pre>
  
  <p>Now i cannot use Test either i need to write </p>
  
  <pre><code>Select name , name + age as Test from myTable
  where (name + age) like '%b%';
  </code></pre>
  
  <p>Now the expression (name + age) can be very big sometimes so cant i give it some alias and use it</p>
  
  <p>Any help is appreciated,</p>
  
  <p>Thank You</p>