If I get the point right, you want to use a computed column in the select query. In that case, you should use something like (sorry for possible syntax errors, I have no SQL available where I currently reside 🙂 ):

select * from

(

select SomeColumWithComputation as ComputedColumn

from SomeTable

) tmp

where ComputedColumn=bla

Cheers! Bert