RE: [sqr-users] number format

["Thompson, Carla" <carla.thompson@gwl.com>]

I've seen the following used to suppress leading blanks:  

let #enroll_amt  = EDIT(TO_NUMBER(ltrim(rtrim(($enroll_amt),' '),' 
')),'B99999999.99')

-----Original Message-----
From: sqr-users-bounces+carla.thompson=gwl.com@sqrug.org
[mailto:sqr-users-bounces+carla.thompson=gwl.com@sqrug.org]On Behalf Of
radhika reddy
Sent: Thursday, May 12, 2005 11:52 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] number format


Hi,

     I have field coming from flat file which is of size 11 and in the 
format of '00000007500'. it has 2 implied decimal. i want to get in the 
format of 75.00 while inserting into the database.

i am trying something like this:

let #enroll_amt  = EDIT(TO_NUMBER(ltrim(rtrim(($enroll_amt),' '),' 
')),'999999999.99')

but i am getting 0's in #enroll_amt field.

any ideas?

Thanks

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE! 
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users