get somthing like alias from a sql database column

[TysonLPrice]

I may be missing the point but you mean something like:

select getdate() 'current date'


and the column name would be 'Current date'