Home Forums SQL Server 2008 SQL Server Newbies Is it possible to rename output data? RE: Is it possible to rename output data?
Doug J.
SSC Eights!
Points: 832
More actions
January 3, 2014 at 3:18 pm
#1677455
Do you mean something like this:
SELECT CASE NodeAlias WHEN '101.101.101.101' THEN 'UniqueName' ELSE 'Larry' END
FROM MyTable
or
SELECT NodeAlias + ' - ' + CASE NodeAlias WHEN '101.101.101.101' THEN 'UniqueName' ELSE 'Larry' END
-Doug