select msgno from actlog where msgno=2565

     MSGNO
----------
      2565
      2565
      2565
      2565
      2565
      2565
      2565
      2565
      2565
      2565
      2565
      2565

Mostly useless as is.
Maybe:

select date(date_time) as date,time(date_time) as time, substr(message,10,2)
as deleted \
 from actlog where msgno=2565 \
 and  cast((current_timestamp-date_TIME)minutes as integer) between 0 and
1440

      DATE         TIME     DELETED
----------     --------     ------------------
2002-02-28     00:05:02     0
2002-02-28     00:05:02     0

There are a lot of choices...

> -----Original Message-----
> From: Pothula S Paparao [mailto:9pothula AT SG.IBM DOT COM]
> Sent: Thursday, March 28, 2002 4:15 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: How to use string operators in select statement - TSM.
>
>
> Hi TSM'ers
> The below is the message from select output (select * from actlog)
> All I want to know is whether or not possible to caputue only
> the message no (ex. ANR2565I) using select query. I tried using string
> operations in select command. didnt help much. If any select expert tried
this pls let me
> know. Im very much intrested to know about it.