Thanks Tom and PW. I did get it to work. I guess after I put the statement in the right place it was just a matter of syntax. Below is...

Thanks PW. Yes I know about the position now, what i can't get right is using the case statement, how to update the last column based on the third column....

OK, Can I update the field CREDIT with a 'CR' based on the field SLBTYP? and if so how can I do it. Thanks Bill

Yes I did shorted things down so it wasn't so long I'll post the statement I used and the file layout.

INSERT INTO INVTEST ...

Tom, I gave that a try and I got further but it was writing the 'CR' into the SLBTYP field instead of the CREDIT field. Would you

have another idea?...

Thanks Tom. This may seam dumb but where would I insert the CASE statement, I did try that before I posted this question but I keep getting an error. I...