12/4/2013 3:13:59 PM

Using the Case Statement in the SELECT Clause to output data based on a value in the table.

SELECT Id, SomethingElseMaybe, CASE WHEN TypeId = 1 THEN 'Type 1 Name' WHEN TypeId = 2 THEN 'Type 2 Name' END AS 'Type', FROM MyTable