WB0TRA

SELECT Member.memberid, Member.locationid, Member.membnbr, ;
  Member.lname, Member.fname, Member.address1, Member.address2, ;
  Member.city, Member.state, Member.zip, Member.emailaddr, ;
  Member.emailoptin, Member.hphone, Member.birthyear, ;
  Member.birthmo, Member.sex, Member.salesrank, Member.incomplete, ;
  Member.sendcard, Member.cardsent, Member.holdmail, ;
  Member.firstvisit, Member.lastvisit, Member.membsince, ;
  Member.pointbal, Member.notes, Member.added, Member.updated, ;
  Member.updtreas, Location.locnbr, Location.locname, ;
  Member.bademail, Member.terminated, Member.seed, ;
  Member.emailupdt, Member.nopoints;
 FROM  gourchef!member INNER JOIN gourchef!location ;
   ON  Member.locationid = Location.locationid;
 WHERE Member.membnbr LIKE ?lcMbrNr;
   AND UPPER(Member.lname) LIKE UPPER(?lcMbrNm);
   AND UPPER(Member.emailaddr) LIKE UPPER(?lcMbrEm);
   AND Member.hphone LIKE ?lcMbrHfon;
 ORDER BY Member.lname, Member.fname