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