Sql中判断字段，替换成相应的其他值。使用case [字段名] when 值 then 要替换的值

SELECT TOP 1000 [BinID]
      ,[Volume]
      ,[Weight]
      ,[Temp]
      ,[Hum]
      ,[DateTime]
      ,[Algorithm]
      ,[PrintNum]
      ,[Quality]=(case [Quality] 
                when 0 then '未评测' 
                when 1 then '数据可靠'
                when 2 then '数据不一定可靠'
                else '数据不可靠'
                end)  
      ,[BackData]
      ,[MiDu]
  FROM [Factory].[dbo].[bindata]
  where BinID = 3

SELECT TOP 1000 [BinID]
      ,[Volume]
      ,[Weight]
      ,[Temp]
      ,[Hum]
      ,[DateTime]
      ,[Algorithm]
      ,[PrintNum]
      ,[Quality]
      ,[BackData]
      ,[MiDu]
  FROM [Factory].[dbo].[bindata]
  where BinID = 3