Really good question, create confusion in mind for the "=" sign used in alias.

I can get clear idea for this.

Thanks,

Keyur Patel

Hi

I too experienced the same result (1,1). I tried it in sql 2008

pls give the detailed explanation for the same......