Martijn,

Thanks, ROWS worked perfect

I changed it to this and am getting what I want.

    UPDATE tblCampaign a SET
    a.BATCHNUM = :BatchNum
    WHERE a.CAMPAIGNID IN (SELECT c.CAMPAIGNID
                            FROM tblCampaign c
                                WHERE c.CAMPAIGNNAME = :CampaignName
                                AND c.CONTACTPERMISSION = 'Y'
                                AND c.BADEMAIL = 'N'
                                AND c.ABORTCAMPAIGN = 'N'
                                AND c.BATCHNUM = -1  )ROWS :Cnt;

Dixon