Hmmmm.... how about something like this:

select left(cast(lastsess_recvd as char(18)), 2) as "Last Did:"
   from nodes where node_name='STORMAN'

Not sure what use the 2 left-most digits of a numeric value are, but there
it is!

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.eyebm DOT com (change eye to i to reply)

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.




Justin Bleistein <justin.bleistein AT SUNGARD DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
05/08/2003 16:28
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Re: TCP/IP connection client error



Does anyone know how to get rid of this error message, well it's more of a
warning. I tried different mathmodes' I still get that error. It's
truncating as you can see. I just don't want that error. Is there an
equilivent to: "2> /dev/null" like in Unix? I want to run this as a server
script eventually... Thanks!.

tsm: tsmserver1>select cast(lastsess_recvd as char(2)) as "Last Did:" from
nodes whe
            re node_name='mypc1'

Last Did:
---------
57
ANR2900W The character string '5723' was truncated during assignment.

                     |
         ............V..................................................
         select cast(lastsess_recvd as char(2)) as "Last Did:" from node


tsm: tsmserver1>

--Justin Richard Bleistein
Unix/TSM Systems Administrator (Sungard eSourcing)
Desk: (856) 566 - 3485
Cell:    (856) 912 - 0861
Email: justin.bleistein AT sungard DOT com