RE: [sqr-users] number format

["Kaithi, Murali" <Murali.Kaithi@spencergifts.com>]

Hi Radhika,
Why don't you try something like 
Let #enroll_amt = to_number($enroll_amt)/100

Murali. 

-----Original Message-----
From: sqr-users-bounces+murali.kaithi=spencergifts.com@sqrug.org
[mailto:sqr-users-bounces+murali.kaithi=spencergifts.com@sqrug.org] On
Behalf Of radhika reddy
Sent: Thursday, May 12, 2005 1:52 PM
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

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
______________________________________________________________________

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