NUMBER columns are actually stored as strings, so you'll always get exactly 2 decimal places. Try this:
<cfif myNum EQ int(myNum)> #int(myNum)# <cfelse> #REreplace(myNum, "0+$", "")# </cfif> cheers, barneyb On Apr 12, 2005 2:38 PM, B G <[EMAIL PROTECTED]> wrote: > There's a simple solution here that is eluding me so please forgive my "end > of day cloud" that is obstructing me. > > I am trying to format a value that is stored in Oracle NUMBER(5,2) datatype > so that if it is a whole number it won't display x.00. > > For example, value 25.75 is fine and displays properly, value 18, should NOT > display 18.00. Likewise, 10.5 should NOT be 10.50. But this is the > behaviour I am getting. > > What are you thoughts? -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202496 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
