select operatorId, address, mfrCustNum from tbl_OPR_ClientOperators opr with (nolock) where ownerId = and fsltablecode = and trim( companyName ) = and trim( address ) = and trim( city ) = and trim( state ) = and zipCode = and mfrCustNum = update tbl_OPR_ClientOperators set mfrCustNum = where operatorId = select operatorId, dateCreated, fsl_choId from tbl_OPR_ClientOperators opr with (nolock) where ownerId = and fsltablecode = and trim( companyName ) = and trim( mfrCustNum ) = order by dateCreated asc