case sql语句

SELECT [au_id],[au_fname],

case [contract] when  0 then '无' when 1 then '有'  end  as '你想要的状态'

FROM [pubs].[dbo].[authors]