• I agree with Phil.

    There must be some character like " ' " or something thats not allowing the transfer.

    Can you give us a snapshot/column & their datatypes of the 2 tables in both sql server and as/400?

    Rex Smith