MI-L:MOD function; unexpected behaviour

2002-11-12 Thread korinne
Hi all, I wish to extract all tuples from a table that have a value without a decimal part in a float field (ie 1 not 1.2; 75 not 75.6) but I cannot seem to get the 'MOD' function to operate as my rusty maths remembers that it should. Theory: (Math based expected behaviour, checked on a

Re: MI-L:MOD function; unexpected behaviour

2002-11-12 Thread B. Thoen
MapInfo's definition of MOD assumes all the numbers itii operates on are integers, and in the range of short integers (SmallInts) as well. You'll have to do some tricky math to use mod for this purpose. Another way to find numbers without fractional components is to use the int function, e.g. find