Is there a way to modify the following select statement so that a status of 
'Failed' is displayed as a status of 'Incomplete' --preserving the display of 
'Missed' as 'Missed' ?


tsm: TSMBL01>select node_name,status from events where (status='Missed') or 
(status='Failed' and result=12)

NODE_NAME              STATUS    
------------------             ----------
I135                            Missed    
JTRAIN3                     Failed    
BL-CHEM-ISO            Missed    


Thank you,
Keith Arbogast