>Like the others said SQLServer isn't natively that dynamic without making the whole TSql statement dynamic. I'm not sure what is consuming the result but I think it's trivial to rename a column of a DataSet object once it gets down to your .Net code.
Thanks Dave, but I don't think I want to go down that road for this particular thing. Thanks for the suggestion though. =0)