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.9200000000001 ?
Is there a way I can assure those extra digits get whacked?

thanks!

[Bob Barrows [MVP]]

shank wrote:

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.9200000000001 ?
Is there a way I can assure those extra digits get whacked?

thanks!

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]

use Round()

--
Roji. P. Thomas
SQL Server Programmer
"shank" <sh***@tampabay.rr.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

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.9200000000001 ?
Is there a way I can assure those extra digits get whacked?

thanks!