I get the data from the 400, I set up a job on sql2000 to qry the as400 via an odbc link and populate the sql2000 table with the data,...

Yes the orginal value is 8,I will try that way as well. The code that Gila put here works as well. So I am going to try to put this...

Thanks so much for the help that worked for me

Walter

I will give those a shot and see what happens thanks