SELECT * FROM dbo.CM_BRANCH WHERE BRANCH_ID='BRN000001055952'

UPDATE dbo.PL_MASTER SET BRANCH_ID='BRN000000001838' WHERE BRANCH_ID='BRN000001055952'