Dynamic Column Aliases

Is it possible to have dynamically aliased columns in a select statement without using dynamic sql?

I'm wondering if there is a way to do something like the following:

SELECT <fieldname> AS <package_name>.<constant> FROM <table>

Thanks in advance.

--Mike Received on Fri Jan 28 2005 - 15:53:40 CST