can we create alias from concatenated columns?

[yehong]

Hi, Is it possible to create an alias from a concatenation of a column and a string or another column? For exmple:

Select ID + ' ' + FName as ID +'2008XYZ'
from employee;

Result: (say ID=1001)

10012008XYZ <--- column alias
1001 John <--value

I have trid but getting errors. I am using SQL Server 2005. Thanks in advanced.

 

[ousoonerjoe]

I do not think this is possible. You would have as many columns as you have values, and i don't think SQL likes that.

I tried both the way you have it listed and various forms of:

SELECT [FName + '2008XYZ'] = ID + ' ' + FName FROM Employee

I just don't think it likes dynamic columns like that.

"If I were to wake up with my head sewn to the carpet, I wouldn't be more surprised than I am right now.

 

[RiverGuy]

No you can't. This is typically done on the front end application or reporting tool.