title: SQL Use alias in Where statement
body: <p>I wounder how I could use an alias in a where statement.</p>
  
  <p>Example :</p>
  
  <pre><code>SELECT SUBSTRING(Column1, 1, 4) + SUBSTRING(Column1, 4, 3)  AS Col1
  FROM MyTable
  WHERE Col1 = 'MySearch'
  </code></pre>
  
  <p>I use MSSQL 2005</p>