Hi there, I need your help.

With this sql query I need this output:

Code:
+--------+--------------------+
| Xtr    | Codigo_FLGHT       |
+--------+--------------------+
| RAS_SD | Zone FlightCA      |
| RAS_SD | Zone FlightN       |
| RAS_SD | Zone FlightOR      |
| RAS_SD | Zone FlightS       |
| RAS_SD | Zone FlightO       |
| RAS_SD | Xtr_SAR            |
+--------+--------------------+
But I have in column `Codigo_FLGHT` ALL `null` values.

Can you help me?

Please check my query below.

Thanks in advance.

Code:
SELECT
	Xtr,
	CASE
WHEN INSTR(Codigo_FLGHT, 'Zone' > 0) THEN
	Codigo_FLGHT = MID(Codigo_FLGHT, 6, 100)
WHEN INSTR(Codigo_FLGHT, 'Xtr' > 0) THEN
	Codigo_FLGHT = Codigo_FLGHT
END Codigo_FLGHT
FROM
	tbl_myflight
WHERE
	1
AND INSTR(Codigo_FLGHT, 'Zone')
AND (Xtr LIKE 'RAS_SD%')
GROUP BY
	Codigo_FLGHT;