SQL 查询显示

我用
例子 ：Select State from product
查询的结果显示 是  0，1，2 这样的数字
0代表在库 ，1代表出库，2代表返厂。
在查询时 如何根据相应的字符 显示对应的汉字状态
用SQL语句 如何实现
谢谢大家 

---

SQL code:


SELECT (CASE STATE
WHEN 0 THEN '在库'
WHEN 1 THEN '出库'
WHEN 2 THEN '返厂'
END)
from PRODUCT

---

SQL code:

select
case State when 0 then '在库' when 1 then '出库' else '返厂' end as State
from product

---

SQL code:

或者

SELECT (CASE
WHEN STATE=0 THEN '在库'
WHEN STATE=1 THEN '出库'
WHEN STATE=2 THEN '返厂'
END)
from PRODUCT

---

SQL code:
select case State when 0 then '在库'
when 1 then '出库'
when 2 then '返厂'
end as State
from product

---

SQL code:
sel