General information
Category:
Coding, syntax & commands
In my case its ok that the trailing zeros get truncated. So this transform function works great for me.
Thanks everybody for your input.
Paul
>>Use transform() instead (without a format code). It won't truncate or round the number.
>>
>>>Is there a way to determine the # of decimal places in a number. I need to export data from tables. Once I know that the field is numeric I need to know how many decimal places there are for the str() command.
>>>
>
>Peter,
>I was thinking along those same lines but transform() does truncate trailing zeros when a format string is not specified. So if your field is N(6,4) and you have a value in it of 8.2500, transform will return 8.25.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only