Thanks I got it right. Created a select statement that yielded the records I wanted and then created a view from them.

Thanks again for the assistance. Enjoy the rest of...

Thanks very much for the speedy reply. This the result I got from print (@w_sql)

CREATE VIEW GI.vGI_CL_200712_EBVG_RJ_Test

AS

DELETE *

FROM ( SELECT * FROM GI.vGI_CL_200712_EBVG_RJ_Test

WHERE ACRMVTTYP_CDE IN...