whereclause based on alias Or columnnumber

[DaHapMan]

Hi there,

Is it possible to build a where-clause based on column-aliases or based on column-number?

e.g.
SELECT col1 as [column1]
, col2 as [column2]
FROM tblTable
WHERE [column1] = N'%aa%'

OR

SELECT col1 as [column1]
, col2 as [column2]
FROM tblTable
WHERE 1 = N'%aa%'

Hope someone can help me soon.
thnx, DaHapMan

 

[swampBoogie]

select * from (
SELECT col1 as column1
,      col2 as column2
FROM   tblTable ) dt
WHERE  column1 = N'%aa%'

Using ordinal numbers will never be possible.

 

[DaHapMan]

thanx!

exactly what I needed