Hi Ali,

The result returned by VAL() function isn't affected by SET DECIMAL setting. So, Val("89.335") will always return 89.335. The display of numeric values is affected by SET DECIMAL command.

>Hi Everybody,
>
>I want to calculate the numeric value of a string with any decimal points. The problem with Val() is: I have to use Set Decimal To for a specific number of decimal points.
>
>For example.
>If Set Decimal to 2
>Val(“89.335”) yields 8.34
>and if Set Decimal to 2
>Val((“89.335”) yields 8.335
>
>Is there any solution?
>
>Thanks,
>Ali