sql server data warehouse: Is there a way to Reference an alias field name in an SQL Statement?

Example:

Select
1 + 1 AS F1,
F1 + 1 AS F2

In article <eWD#ZnVkGHA.1260@TK2MSFTNGP05.phx.gbl>,
kent_prokopy@hotmail.com says...
[quoted text, click to view]
Not within the one SELECT. I don't know if it will help, but you can
kind of do it with a sub select (also called a derived table)

eg

SELECT
F1
,F1 + 1 As F2
FROM (SELECT 1 + 1 AS F1 FROM ... )
--
Regards
Darren Gosbell [MCSD]