RE: [sqr-users] number format

["Knapp, Richard" <KnappR@umsystem.edu>]

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