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
Today is tomorrow's yesterday.