MSSQL ~ CASE

SELECT         StringB, CASE StringB WHEN '1' THEN 'a' WHEN 0 THEN 'b' ELSE '' END
FROM             Table

http://www.1keydata.com/tw/sql/sql-case.html