Present a true or false conditional as a query column in T-SQL.

SELECT Foo, CASE WHEN Bar = 'Baz' THEN 'Yes' ELSE 'No' END as Qux
FROM Whatever