CODEWITHSUNDEEP
sqlsql-servert-sql
wusher
wusher

Reputation: 12451

Using an Alias column in the where clause in ms-sql 2000

I know you cannot use a alias column in the where clause for T-SQL; however, has Microsoft provided some kind of workaround for this?

Related Questions:

Upvotes: 11

Views: 12103

Answers (2)

Adam
Adam

Reputation: 7910

Depending on what you are aliasing, you could turn it into a user defined function and reference that in both places. Otherwise your copying the aliased code in several places, which tends to become very ugly and means updating 3+ spots if you are also ordering on that column.

Upvotes: 1

Jim V.
Jim V.

Reputation: 2177

One workaround would be to use a derived table.

For example:

select *
from 
   (
   select a + b as aliased_column
   from table
   ) dt
where dt.aliased_column = something.

I hope this helps.

Upvotes: 28

Related Questions