• 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