SQL Syntax : CASE

SELECT CASE ("欄位名") AS "別名"
  WHEN "條件1" THEN "結果1"
  WHEN "條件2" THEN "結果2"
  ...
  [ELSE "結果N"]
  END
FROM "表格名";