I enter the following select command and get this result.

select nodename,msgno,date_time,message as "Elapsed time" from actlog where
nodename like 'TN%BR%' and msgno=4964 and date_time between '2000-04-17
18:00:00' and '2000-04-18 07:00:00' order by nodename


NODENAME                     MSGNO     Elapsed time
DATE_TIME
------------------     -----------     ------------------
------------------
------------------
TN5270-BR3200                 4964     ANE4964I Elapsed
TN5270-BR3200                 4964     ANE4964I Elapsed
2000-04-18
                                        processing time:
01:04:22.000000

                                        02:57:40

TN5271-BR3210                 4964     ANE4964I Elapsed
2000-04-18
                                        processing time:
00:10:55.000000

                                        02:04:42

What I want is this result:

 NODENAME                     MSGNO     Elapsed time
DATE_TIME
------------------     -----------     ------------------
------------------
------------------
TN5270-BR3200                 4964       02:57:40
TN5270-BR3200                 4964       02:57:40
2000-04-18

01:04:22.000000


TN5271-BR3210                 4964       02:04:42
2000-04-18

00:10:55.000000

 Can anyone tell me how to get this result.

___________________________________
Cynthia W. Ousley
IT Server Management, Birmingham
(205)801-0894  Fax(205)583-4518
cousley AT amsouth DOT com