Or, are you asking how to rename the columns in the result set only? You do that by using AS:
SELECT RealColName AS NewColName FROM... That only changes the column name in the result set, not the underlying table. - Andy O. ________________________________________ From: Aaron T. Rohyans [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 06, 2008 11:54 AM To: NT System Admin Issues Subject: SQL help... Hi all, Is anyone aware of a way that I can run a SQL query (SQL 2000) and update the results I get *without* modifying the actual table? In other words, I just want the query to spit out raw data, and use another function to go through and re-label certain fields within the results to say something else. Will the select replace function do that, or will it modify the table? Or is there a better way to do it? Thanks for any help! Aaron T. Rohyans Director of Information Systems IDC-USA [EMAIL PROTECTED] ~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~ ~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~
