ROUND function

[Jeff Lusted]

Hi Colleagues!

I'm not sure who answered Mark's question on the ROUND function.
Depending on how you read the answer, the answer is ambiguous...

how come the round(x,n) ("Round to nearest integer") function has two
arguments?
VOQL-TEG Answer: This is an error and will be corrected in the next
version of the document.

There is an error, but I'm not sure which bit is thought to be an error
in the document. I think it is "Round to nearest integer", which is far
too restrictive. The function with two args is supported as far as I
know by the main manufacturers (both parameters are required in SQL
Server). My understanding is it rounds to the given number of decimal
places, with the default being to round to the nearest integer. You use
a negative number to round to the left of the decimal point.

I didn't want to alter over another member of the TEG, so please alter
the answer, kind colleague!

Kindest regards
Jeff
-- 
Jeff Lusted               tel: +44 (0)116 252 3581
Astrogrid Project         mob: +44 (0)7973 492290
Dept Physics & Astronomy  email: jl99 at star.le.ac.uk
University of Leicester   web: http://www.astrogrid.org