ChrisM@Work,

I know how to do it. I didn't say it could not be accomplished some other way.

My original post said that an alias cannot be referred to in a subsequent calculation like MS Access allows.

You chose to take issue with that, indicating I was giving misinformation in regards to later versions of SQL Server.

The fact is...an alias cannot be referred to in a subsequent calculation in the same way that MS Access allows. Period.

In the future, please don't say I'm wrong, if I'm not.