>I have a series of numbers with up to 9 significant digits after the decimal point and would like to truncate the character values down to 4 significant digits.
>
>For example I have the following two values:
>
>123.456789012
>98.765432109
>
>I want to return these values:
>
>123.4567
>98.7654
>
>I can write a function to use something like ATC() to find the decimal point but is there a better way? Sergey, you will no doubt have something interesting and insightful so thanks in advance...:>)
? INT(m.lnNumber)+int((m.lnNumber - INT(m.lnNumber))*10^4)/10^4
PS:
? INT(m.lnNumber*10^4)/10^4
Cetin