• Thanks for your reply

    update tblcustomer

    set Supid = Supid

    I don't mind if this fails.

    As long as the supid and manid are not part of the SET clause of an update I should be ok?