Hello BillyWilly,
quote:
No big deal - I'll just do some casting during division to get the 12 precision I want - just found this to be interesting.
it is interesting!
For further information on decimal data type see
http://standards.ieee.org/reading/ieee/std_public/description/busarch/854-1987_desc.html or http://www2.hursley.ibm.com/decimal/decbits.html .
Hope this will feed your appetite for information
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]