1. Why are you storing numbers as characters?

2. If you want to know if FPW will crash on a zero value, why not put in a zero value and see what happens instead of asking here what will happen?


>I have decided to copy the offset values to another table. At that point, it becomes whole numbers again instead of "0000000000001.00" (yet, the file is character type). As I also need to reverse the amount of offset records, this is the program I came up with, yet, it is not working. What am I doing wrong here? Also, will this crash if an "0.00" appears?
>
>Sample:
>5.50 changes to "-000000000005.50"
>-24.00 changes to "0000000000024.00"
>...
>
>IF VAL(nbillamt) < 0
> TRANSFORM(ABS(VAL(nbillamt)),"@LZ 9999999999999.99")
>ELSE
> TRANSFORM(VAL(nbillamt),"@LZ 9999999999999.99")
> REPLACE nbillamt WITH "-" + SUBSTR(nbillamt,2)
>ENDIF
>
>
>Chuck