rounding in sql

Can anyone provide any links or information about the differences in
rounding between access 97 and sql 2000.See
http://support.microsoft.com/defaul...en-us%3B196652.
--Mary
On Thu, 12 May 2005 10:10:28 -0500, "Ben Wallace \(3\)"
<kixman@.excite.com> wrote:

>Can anyone provide any links or information about the differences in
>rounding between access 97 and sql 2000.
>|||You might also like to know that truncation and rounding at
implementation defined in Standard SQL.|||> You might also like to know that truncation and rounding are
> implementation defined in Standard SQL.
I find that weird. Doesn't that limit portability a lot? Or at least increas
e test time? What was
the rational behind making it implementation defined? Vendors couldn't agree
because of current
implementation?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"--CELKO--" <jcelko212@.earthlink.net> wrote in message
news:1115954756.702609.23790@.o13g2000cwo.googlegroups.com...
> You might also like to know that truncation and rounding at
> implementation defined in Standard SQL.
>