RE: [sqr-users] number format

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

Thanks Murali. You are so correct.

>From: "Kaithi, Murali" <Murali.Kaithi@spencergifts.com>
>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 14:28:16 -0400
>
>Hi Radhika,
>Now just do inserts, I don't think you need any more edits.
>
>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 2:22 PM
>To: sqr-users@sqrug.org
>Subject: RE: [sqr-users] number format
>
>
>yeah, you are correct. and now i get the output #enroll_amt =  75.000000
>
>when i want to insert into table i want that to be 75 and if the number
>is 75.36 then 75.36.
>
>Thanks.
>
> >From: "Kaithi, Murali" <Murali.Kaithi@spencergifts.com>
> >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 14:12:37 -0400
> >
> >Hi Radhika,
> >I thought that is what you want when you said your input has 2 implied
> >decimals, I still think my suggestion should work.
> >Correct me if I am wrong.
> >
> >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 2:02 PM
> >To: sqr-users@sqrug.org
> >Subject: RE: [sqr-users] number format
> >
> >
> >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
> >
> >______________________________________________________________________
> >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
>
>_________________________________________________________________
>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
>
>______________________________________________________________________
>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

_________________________________________________________________
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