Michael,

Thanks for the reply. I thought the SQL Update would be easiest, but I receive an error. It is expecting my AS400 file to be in the VFP dbc. Here is my code:

CREATE CONNECTION .....

SQLEXEC(lnHandle, "SELECT * FROM QS36F.GMBIAP6 GMBIAP6;
WHERE GMBIAP6.WDC=' ' AND GMBIAP6.WSBTC = ' '", 'cRefunds')

UPDATE QS36F!GMBIAP6 SET GMBIAP6.WSBTC = 'Y'

SQLDISCONNECT(0)

DELETE CONNECTION .....


What am I doing wrong? Thanks again for your help! :)