So you want to display a different value than the actual result based that
result? That would be a simple case statement in the select clause.
Example:
SELECT
CASE RowName
WHEN 'RealValue1' THEN 'NewValue1'
WHEN 'RealValue2' THEN 'NewValue2'
WHEN 'RealValue3' THEN 'NewValue3'
ELSE 'Other'
END
FROM...
- 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> ~
