I think this is what you want:
Select * from actlog where left(message,10)='ANR2565I'
Regards,
Al
mobeenm <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
02/28/02 03:21 AM
Please respond to "ADSM: Dist Stor Manager"
To: [EMAIL PROTECTED]
cc:
Subject: Re: How to use string operators in select statement - TSM.
Sree Kumar,
Its absolutely possiblem to do that. Try the following
select * from actlog where message like 'ANR2565I%'
I think this should do the trick. Hope the climate in Bangalore is good
:-)
Regards
Mobeen
Mobeen Mahamood C.M
Systems Manager Lead
Micron Semiconductor Asia
Singapore
> -----Original Message-----
> From: Pothula S Paparao [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 28, 2002 5:15 PM
> To: [EMAIL PROTECTED]
> 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.
>
> Thanks in advance.
>
>
> DATE_TIME: 2001-12-30 00:00:02.000000
> MSGNO: 2565
> SEVERITY: I
> MESSAGE: ANR2565I 0 schedules for immediate client actions have been
> deleted.
>
>
> Regards
>
> Sreekumar.
> SO
> IBM Singapore.
> Phone : 65-8402634
>
******************* PLEASE NOTE *******************
This message, along with any attachments, may be confidential or legally
privileged. It is intended only for the named person(s), who is/are the
only authorized recipients. If this message has reached you in error,
kindly destroy it without review and notify the sender immediately. Thank
you for your help.
**********************************************************
