>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.