ok i keep getting
MERGE: RECORDS= 158720 LINES= 158720
when i ex the report. Is there a way to suppress it ... just get me my hold file ... here is the code.

SET HOLDDEFAULT=ALPHA
JOIN CLEAR*
JOIN PRV30_TAX_ID IN PRV30 TO PRV32_TAX_ID IN PRV32 AS A
END
TABLE FILE PRV30
PRINT PRV30_TAX_ID
PRV30_TAX_ID_SUFFIX
PRV30_PRV_LAST_NAME
PRV32_ADDR_TYPE
PRV32_ADDR_LINE_1
PRV32_ADDR_LINE_2
PRV32_CITY
PRV32_STATE
PRV32_ZIP_CODE
ON TABLE HOLD AS LONGLIST
END

Thanks

Try with:

SET MESSAGE = OFF

Regards,
Mikel

Thank You that worked perfectly!