Both numbers are the same. Enterprise manager is displaying it cleanly, where as you probably need a NumberFormat around the cf output of the variable.
Floating point numbers are generally depicted with the E-x notation as you never know quite where that decimal point is going to be. 0.0000000003027778 ~ 3.0277780000000001E-10 regards Stephen > Sorry its a float length of 8 dataype, > > -----Original Message----- > From: John McCosker [mailto:[EMAIL PROTECTED]] > Sent: Monday, March 11, 2002 4:22 PM > To: CF-Talk > Subject: sql data type wierdness > > > greetings, > > CF outputs this value from MS SQL SERVER 7.0 as > > " 3.0277780000000001E-2 ", > > in enterprise manager the value looks like this > > " 0.03027778 " > > any help would be appreciated, > > respectfully, > > J > > > ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
