select operatorId from tbl_OPR_ClientOperators where ownerId = 1644 and nullif( mfrCustNum, '' ) is null order by operatorId desc update tbl_OPR_ClientOperators set mfrCustNum = , customfld_4 = 'Y' where operatorId = and ownerId = 1644 and fsltablecode = 'MFR'