In case you are interested...
I found out what the problem was.. my numbers were padded with SPACES. Freaking mainframe...
So here's how I solved it, after I dumped the whole thing in a VARCHAR2(4000) and substring'd it:
FPS_ACC_HK_POINTS1 POSITION(1281:1283)
CHAR
NULLIF FPS_ACC_HK_POINTS1=BLANKS
"TO_NUMBER(REPLACE(:FPS_ACC_HK_POINTS1, CHR(0)))",
that should allow for me to post something off-topic next week!
Have a great weekend all
Lisa Koivu
Pc Breaker (I'm up to TWO!) and DBA
Ft. Lauderdale, FL, USA
GO VIKINGS !!! WOO HOO!