RE: [sqr-users] number format

["radhika reddy" <radhika_05@hotmail.com>]

may be not,  as sometimes the number might be 00000065400 then my result 
shoud be 654.00

or

00000008967 then 89.67

Thanks.

>From: "Knapp, Richard" <KnappR@umsystem.edu>
>Reply-To: "This list is for discussion about the SQR database 
>reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
>To: "This list is for discussion about the SQR database reportinglanguage 
>fromHyperion Solutions." <sqr-users@sqrug.org>
>Subject: RE: [sqr-users] number format
>Date: Thu, 12 May 2005 12:56:06 -0500
>
>
>I assume you want to ltrm the 0's, yes?
>
>Richard Knapp
>Database Programmer/Analyst
>Institutional Research and Planning
>University of Missouri System
>573-882-8856
>knappr@umsystem.edu
>
>-----Original Message-----
>From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
>[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
>radhika reddy
>Sent: Thursday, May 12, 2005 12: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
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users

_________________________________________________________________
Don’t just search. Find. Check out the new MSN Search! 
http://search.msn.click-url.com/go/onm00200636ave/direct/01/


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