DECLARE @PARTYMASTID VARCHAR(40),@FULLADD VARCHAR(500),@AREANAME VARCHAR(40),@VILLAGENAME VARCHAR(40),
@TalukNAME VARCHAR(40), @DISTRICTNAME VARCHAR(40),@indexno int
DECLARE h1 CURSOR FOR 
SELECT PARTYMASTID,RTRIM(LTRIM(ADD1))+RTRIM(LTRIM(Add2))+RTRIM(LTRIM(Add3)) AS FULLADD,AREANAME,VILLAGENAME,TalukNAME,DISTRICTNAME FROM PartyAll
WHERE PARTYMASTID NOT IN('P2_7695_#H','P2_7697_#H')
OPEN h1
FETCH NEXT FROM h1 INTO @PARTYMASTID,@FULLADD,@AREANAME,@VILLAGENAME,@TalukNAME,@DISTRICTNAME
WHILE @@FETCH_STATUS = 0
BEGIN
	set @indexno = 0
	SELECT @indexno = CHARINDEX(@AREANAME,@FULLADD)
	if @indexno = 0
	begin
		UPDATE PartyMast SET Add2 = LTRIM(RTRIM(Add2)) + ' ' + @AREANAME where PartyMastId = @PARTYMASTID
	end
	
	set @indexno = 0
	SELECT @indexno = CHARINDEX(@VILLAGENAME,@FULLADD)
	if @indexno = 0
	begin
		UPDATE PartyMast SET Add3 = LTRIM(RTRIM(@VILLAGENAME)) + ' ' + LTRIM(RTRIM(Add3))  where PartyMastId = @PARTYMASTID
	end
	FETCH NEXT FROM h1 INTO @PARTYMASTID,@FULLADD,@AREANAME,@VILLAGENAME,@TalukNAME,@DISTRICTNAME
END
DEALLOCATE H1