Heres some code that may be what you are looking for and sets the rows where the Procedurecode = '0062A' and '0062B' with 86, but doesnt do that where the Procedure Id=86.
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
_________________________________________________________________________
SSC Guide to Posting and Best Practices