admin 2020.09.18 04:30 Views : 23
Select
(CASE
WHEN NICK_NAME IS NOT NULL
THEN MNAME || ' '|| NICK_NAME
ELSE
MNAME || ' '|| MKNAME
END)
AS "MISSION NAME"
from MISSIONARY where MID = :P89_MISSIONARY_ID
