From: "Tony Ingenoso" 

The 754 standard has four different types of rounding availbale - up, down,
nearest, and chop.  .NET and SQL server are probably using different NPX
settings.

See if there's some app settings that will allow you to program the kind of
rounding you need.

"chad"  wrote in message
news:3dcbd8a3{at}w3.nls.net...
> i feel all dirty for making a post so pro microsoft like i did before (in
> the anti MS rant thread.)  they really are evidence of the adage: absolute
> power corrupts absolutely.
>
> so i just got this from one of the development vp's in my company, in an
> email entitled "only in Microsoft software."  i figured i
would send it
> along, to help cleanse myself.
>
> .NET's Math.Round function rounds "down" 0.5 (i.e. 3.45 rounds to 3.4)
> SQL Server's decimal-rounding rounds "up" 0.5 (i.e. 3.45
rounds to 3.5)
>
> Another "win" for MS :(
>
> chad - feeling a little better now
>
>

--- BBBS/NT v4.01 Flag-4