数据库中的（if-else）

SELECT
PART_NUMBER,
DESCRIPTION,
QTY,
UN,
a.LOCATION originLocation,
PTS,
STATUS,
CALIBRATION,
SYSTEM,
CODE,
b.CODE,
c.city_name
  ,
 CASE WHEN a.LOCATION is null THEN c.city_name
             WHEN a.LOCATION = '    '   THEN c.city_name
     ELSE a.LOCATION END as LOCATION
FROM
DEVICE a
LEFT OUTER JOIN CLASSROOM b ON LABID = b.ID
LEFT OUTER JOIN CITY c ON b.LOCATION = c.id
ORDER BY
a.CRT_TIME DESC;