SqlServer Case

Select SellInOut=Case
   When InOut='0' Then '内销'
   When InOut='1' Then '外销'
  end
From TT_CollKind