Hi Brett, Catching up when I can....
<satirical? mode> >Call me a cynic but I can just see this returning a value of 0.000000000001. I don't >know why but it happens to me ALL the time... As it should when you think about it.... >But perhaps I shouldn't admit to such things on a public list? ;) What, that you don't know that CF does its arithmetic in Floating Point? </> One of the tricks with CF is to remember that fact and force things to integers when you are doing "maths that matter", like money things. (FYI to be platform neutral we treat all money as cents and save in Integer type database fields) Hence the max(oldnum,0) function is the best way to go as it will return a true zero, not a near miss :-), but both ideas were very clever, IMHO -- Yours, Kym --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
