select PProduceID,SUBSTRING(PProduceID,3,len(PProduceID)) from dbo.Carton_BG_PProduceInfo

where PProduceID  like  '2015%' ;

select * into Carton_BG_PProduceInfo160113 from Carton_BG_PProduceInfo;
update Carton_BG_PProduceInfo set PProduceID = SUBSTRING(PProduceID,3,len(PProduceID)) 
where PProduceID  like  '2015%'