Arithmetic overflow error

[shank]

I got the following error: Arithmetic overflow error converting numeric to
data type numeric
I'm sure it was one of my currency fields. However, the real total of that
column was $776.92
How did it get submitted as $776.9200000000 001 ?
Is there a way I can assure those extra digits get whacked?

thanks!

[Bob Barrows [MVP]]

Re: Arithmetic overflow error

shank wrote:[color=blue]
> I got the following error: Arithmetic overflow error converting
> numeric to data type numeric
> I'm sure it was one of my currency fields. However, the real total of
> that column was $776.92
> How did it get submitted as $776.9200000000 001 ?
> Is there a way I can assure those extra digits get whacked?
>
> thanks![/color]

Come on! You've been on these groups log enough to realize that we aren't
looking over your shoulder! Show us the code. Seriously, would you be able
to answer this question given this information?

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Roji. P. Thomas]

Re: Arithmetic overflow error

use Round()

--
Roji. P. Thomas
SQL Server Programmer
"shank" <shank@tampabay .rr.com> wrote in message
news:%23pqCpUHC EHA.2804@tk2msf tngp13.phx.gbl. ..[color=blue]
> I got the following error: Arithmetic overflow error converting numeric to
> data type numeric
> I'm sure it was one of my currency fields. However, the real total of that
> column was $776.92
> How did it get submitted as $776.9200000000 001 ?
> Is there a way I can assure those extra digits get whacked?
>
> thanks!
>
>[/color]