DECLARE TAccCur CURSOR FOR SELECT AccCode FROM ACCOUNT_MASTER WHERE AccName LIKE '%ALOK BACCHAWAT%' OPEN TAccCur DECLARE @AccCode Varchar(255) FETCH NEXT FROM TAccCur INTO @AccCode WHILE (@@FETCH_STATUS <> -1) BEGIN PRINT @AccCode DECLARE @TAccCurDelete NVARCHAR(4000) SET @TAccCurDelete='DELETE FROM ACCOUNT_MASTER WHERE AccCode ='+ ''''+ @AccCode + '''' EXEC (@TAccCurDelete) FETCH NEXT FROM TAccCur INTO @AccCode END DEALLOCATE TAccCur