I'll take a look at those thanks guys
> Looks like CEIL() or CEILING() is the function you're looking for: > http://db.apache.org/derby/docs/10.2/ref/refderby.pdf > > HTH, > Jon > On Dec 8, 2007, at 11:18 PM, Dave l wrote: > > > if i change the select statement to: > > SELECT center_id, address1, city, state, postalcode, state, > > ROUND((ACOS((SIN(#lat_A#/57.2958) * SIN(#lat_B#/57.2958)) + > > > > it changes the error to: > > 'ROUND' is not recognized as a function or procedure. > > > > > > so i might be sol on this tut > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294431 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
