Select just reads the table, Insert is what will do the modification.
Z Edward E. Ziots Netwok Engineer Lifespan Organization MCSE,MCSA,MCP,Security+,Network+,CCA Phone: 401-639-3505 -----Original Message----- From: Aaron T. Rohyans [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 06, 2008 12:54 PM 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> ~
