You can use CAST or CONVERT on the MS-SQL side, or better yet, use one of the ColdFusion formatting functions (NumberFormat, DecimalFormat, etc) to produce the exact output you're after. Regards,
John Paul Ashenfelter CTO/TransitionPoint ----- Original Message ----- From: "Hugo Ahlenius" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, June 17, 2003 10:08 AM Subject: SQL float format > Hi, > > I have values stored as "float" in an MSSQL2k table. If i store "55.5" as > a value in this column, I sometimes get back "55.500000000000" (a lot of > decimals). And sometimes "55" returns "55.0". (returns = cfquery) > > Any hints tips, references for some RTFM? > > /H. > > > > > ------------------------------------------------------------- > Hugo Ahlenius E-Mail: [EMAIL PROTECTED] > Project Officer Phone: +46 8 230460 > UNEP GRID-Arendal Fax: +46 8 230441 > Stockholm Office Mobile: +46 733 467111 > WWW: http://www.grida.no > ------------------------------------------------------------- > > > > > ########################################### > > This message has been scanned by F-Secure Anti-Virus for Microsoft > Exchange. > For more information, connect to http://www.F-Secure.com/ > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
