create table #procedurecode
( procedureid int primary key ,
 procedurecode varchar(10),
 ParentProcedureID int)

Insert into #procedurecode(procedureid, procedurecode)
select 86, '0062'
union all
select 87,'0062A'
union all
select 88,'0062B'

Update
	pc
Set
	pc.ParentProcedureID=p.procedureid
from
	#procedurecode pc
	JOIN #procedurecode p on Left(pc.procedurecode,4)=P.procedurecode
Where 
	Right(pc.procedurecode,1) like '[A-Z]'

Select * From #procedurecode

Update
	pc
Set
	pc.ParentProcedureID=p.procedureid
from
	#procedurecode pc
	JOIN #procedurecode p on Left(pc.procedurecode,4)=P.procedurecode