[no subject]

["Logu Chakravarthi (IT Dept. - Langley)" <logu_chakravarthi@OWFG.COM>]

Hi,

        I've written a SQR to carry over the year end balances to the next
year. That means it picks up some special accumulators and their balances
from CAN_ERN_BALANCE table and update the table after the first pay calc for
the new year. The problem I am facing is it has inserted 1 in the field
BALANCE_YEAR instead of 1999. I know that it has something to do with the
number-format, but can anyone suggest me what the exact problem is. Thanks
in advance.

Thanks Nathan for your reply for my last question.

C.Logu