Sure. The SQL is simply: UPDATE <MyTable> SET <MyCol> = log(<MyNumber>)
Or if you want common (base 10) logarithms instead of the natural kind: UPDATE <MyTable> SET <MyCol> = log(<MyNumber>) / log(10) <MyCol> must be of type Float or decimal. Simon Roy wrote:
Hi, Is it possible to use a log function when updating a column? Thank you, Simon _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
_______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
