| Subject | Rounding function? | 
|---|---|
| Author | Joe Martinez | 
| Post date | 2003-02-05T06:15:08Z | 
Does FB 1.0 have a rounding function?
I want to issue a command that sets a particular field as the value of
another field, multiplied by 2.3, but I want the result rounded to 2
decimal places.
So, it would be something like:
update mytable set field1 = ROUND(field2 * 2.3,2)
Does such a function exist in FB 1.0, and if so, what is the exact syntax?
Thanks,
Joe
            I want to issue a command that sets a particular field as the value of
another field, multiplied by 2.3, but I want the result rounded to 2
decimal places.
So, it would be something like:
update mytable set field1 = ROUND(field2 * 2.3,2)
Does such a function exist in FB 1.0, and if so, what is the exact syntax?
Thanks,
Joe