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> ~
