Andy's methods are the best and more preferable for performance. However, if modifications that you want to do are very complex, you could simply copy data into a temporary table (i.e. tables who's name begins with '#' character), and make all modifications to data in the temporary table, and then return data from the temp table.
Lenny On 2/6/08, Aaron T. Rohyans <[EMAIL PROTECTED]> wrote: > > > 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> ~
