>>How can I find the position of the decimal point in a numerical value. I tried to convert the number to string but it rounded the value.
>>
>>thanks
>>Nick
>
>You can use TRANSFORM(numericvalue) (or any of the PADx() functions) and parse the resultant string to get the number of decimal places.

It doesn't always work; try:

CREATE CURSOR DEMO (Num1 N(10,3))
INSERT INTO DEMO1 VALUES (1.0)
INSERT INTO DEMO1 VALUES (1.1)
INSERT INTO DEMO1 VALUES (1.01)
INSERT INTO DEMO1 VALUES (12345)
SCAN
   ? TRANSFORM(Num1)  && first and last are wrong
   ? PADL(Num1,16)    && this works
ENDSCAN