Re: Leading zero help needed!

["Hins, Thomas D." <Thomas-Hins@OUHSC.EDU>]

Jason,
  I believe if you just do a let statement to a # variable you should be
okay.
  such as   let #This_time = Substr($in,30,10) or whatever you have.
Tom Hins
Information Technology - Application Solutions
University of Oklahoma Health Sciences Center
P.O. Box 26901
Oklahoma City, OK  73190
Phone:(405) 271-2262 Ext. 50213
Fax: (405) 271-2352



-----Original Message-----
From: Jason Rupp [mailto:jrupp@TECHNEGLAS.COM]
Sent: Tuesday, December 11, 2001 10:44 AM
To: SQR-USERS@list.iex.net
Subject: Leading zero help needed!


Hi all,

I am creating a report that is reading data in from a flat file.  There
is an HOURS field that is 10 bites long and is padded with zeros if the
number of hours does not fill the whole string.  I.E,

0000000043

I need to get rid of the leading zeros and just insert the actual
number.  Is there an easy way to do this?

Thanks!!