Case expression in SQL Server allows for values to be replaced in the result set based on comparison values.

e.g.

SELECT ID, Title= CASE Gender WHEN ‘M’ THEN ‘Mr’ WHEN ‘F’ THEN ‘Mrs’ END FROM EMPLOYEE.