How do I take a very very large number like: 4.7119E+219 and return the Mod?
The table will hold the value of 4.7119E+219 but when I actually try to use it in Query Analyzer it get the error below.
How can I use the mod function with very very large numbers?
Server: Msg 403, Level 16, State 1, Line 1
Invalid operator for data type. Operator equals modulo, type equals float.
The utility of this is using prime numbers to identify by factors the related records of a primary table.