>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.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao