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
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