update opr set opr.mfrCustNum = dst.dstBranchId + '-' + opr.mfrCustNum from tbl_OPR_ClientOperators opr inner join tbl_CDR_Distributors cdr on cdr.cdr_recordId = opr.distrib1 and cdr.ownerId = opr.ownerId and cdr.fsl_tablecode = opr.fsltablecode inner join tbl_DST_Distributors dst on dst.dstId = cdr.fsl_dstId where opr.ownerId = 4994 and opr.fsltablecode = 'DST' and left( opr.mfrCustNum, 4 ) != dst.dstBranchId + '-' and len( dst.dstBranchId ) = 3