select operatorId from tbl_OPR_CLientOperators where ownerId = 1644 and fsltablecode = 'MFR' and ( mfrCustNum is null or mfrCustNum = '' or mfrCustNum = '0') update tbl_OPR_ClientOperators set mfrCustNum = where operatorId = and ownerId = 1644 and fsltablecode = 'MFR'