SQL Server Case Statement in SELECT Clause

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

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