Arithmetic overflow occurred

[william-paul_philibert]

Bonjour,

   I am trying a simple math calcul that my tabletop cheap calculator can easily handle but Sybase just can't ....

declare @totalsize float

select @totalsize=(894720*4096/1048576)

Arithmetic overflow occurred ... Sybase errorcode 3606

No matter what type I use (numerci, bigint, int, nameit), nothing is working, my database is simple unable to handle this calcul.

Anyone has an idea what's going on!?

[william-paul_philibert]

I thank you guys, both of you, well explained and fix my issue using the convert(float) as I don't always know what the numbers will be.

This was, at the very least, real tricky, this is a lesson I won't forget.

Thanks again to you.