Remove Duplicates

--select * from LOGISTICSADDRESSZIPCODE where ZIPCODE = '92620'

create table #TempRECID (myRecID bigint)

insert into #TempRECID (myRecID)
select A.RECID
from LOGISTICSADDRESSZIPCODE A
inner join LOGISTICSADDRESSZIPCODE B
on A.ZIPCODE = B.ZIPCODE
and A.COUNTY<>B.COUNTY
and B.COUNTY <> ''
--and B.ZIPCODE = '92620'

--select * from #TempRECID

delete AA from LOGISTICSADDRESSZIPCODE AA
inner join #TempRECID B on AA.RECID = B.myRecID
--where RECID = '5637148309'

drop table #TempRECID

--select * from LOGISTICSADDRESSZIPCODE where RECID =  '5637148309'

===========================================================
update dbo.LOGISTICSADDRESSZIPCODE
set ZIPCODE = '0' + ZIPCODE
where len(zipcode) = 4