Thanks very much

Bill Thoen a écrit :
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

Reply via email to