[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] number format
- Subject: [sqr-users] number format
- From: "radhika reddy" <radhika_05@hotmail.com>
- Date: Thu, 12 May 2005 12:51:32 -0500
- Bcc:
- Delivery-date: Thu, 12 May 2005 12:52:38 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
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